OraFAQ Forum: SQL & PL/SQL » where we will use hints in SQL ?and Why? plz tell me with the example ?

Home » SQL & PL/SQL » SQL & PL/SQL » where we will use hints in SQL ?and Why? plz tell me with the example ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

where we will use hints in SQL ?and Why? plz tell me with the example ? [message #217370]

Thu, 01 February 2007 22:37

victoryhendry
Messages: 96
Registered: January 2007
Location: Bangalore

Member

where we will use hints in SQL ?and Why? plz tell me with the example ?

Report message to a moderator

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

BlackSwan
Messages: 26766
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

Report message to a moderator

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

Maaher
Messages: 7065
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

Bill B
Messages: 1971
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.

Report message to a moderator

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

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

I've used Driving_Site a few times with good results.

Report message to a moderator

Previous Topic:	Need to know how this query works
Next Topic:	Oracle SQL is breaking

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 12:09:26 CST 2024