Home » SQL & PL/SQL » SQL & PL/SQL » where we will use hints in SQL ?and Why? plz tell me with the example ?
where we will use hints in SQL ?and Why? plz tell me with the example ? [message #217370] Thu, 01 February 2007 22:37 Go to next message
victoryhendry
Messages: 95
Registered: January 2007
Location: Bangalore
Member

where we will use hints in SQL ?and Why? plz tell me with the example ?
Re: where we will use hints in SQL ?and Why? plz tell me with the example ? [message #217375 is a reply to message #217370] Thu, 01 February 2007 23:11 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
This is NOT an expert question which can be answered by reading the fine Concepts Manual found at http://tahiti.oracle.com
Re: where we will use hints in SQL ?and Why? plz tell me with the example ? [message #217495 is a reply to message #217375] Fri, 02 February 2007 09:18 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Hints are placed right after the SELECT keyword.

MHE

[Updated on: Fri, 02 February 2007 09:18]

Report message to a moderator

Re: where we will use hints in SQL ?and Why? plz tell me with the example ? [message #217540 is a reply to message #217370] Fri, 02 February 2007 12:38 Go to previous messageGo to next message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
And as for when to use them, the answer is almost never. If your indexes are correct and your statistics are up-to-date, the optimizer will almost NEVER have to use a hint. And in reality, a hint will almost always slow down the query. The only hint that might be commonly used if FIRST_ROW AND ALL_ROWS.
Re: where we will use hints in SQL ?and Why? plz tell me with the example ? [message #217922 is a reply to message #217540] Tue, 06 February 2007 02:11 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I've used Driving_Site a few times with good results.
Previous Topic: Need to know how this query works
Next Topic: Oracle SQL is breaking
Goto Forum:
  


Current Time: Tue Dec 06 04:41:13 CST 2016

Total time taken to generate the page: 0.42251 seconds