Home » RDBMS Server » Server Administration » Oracle Hints
Oracle Hints [message #525255] Fri, 30 September 2011 06:50 Go to next message
Messages: 122
Registered: March 2009
Location: India
Senior Member

What is the use of using Hints within SQL statements w.r.t query tuning? How to know which hint to use when??

Re: Oracle Hints [message #525259 is a reply to message #525255] Fri, 30 September 2011 07:08 Go to previous message
Messages: 3124
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
prejib wrote on Fri, 30 September 2011 13:50
How to know which hint to use when?

Basically you use a hint when you are sure that YOU know better than the dozens on highly trained people who wrote the Oracle Query optimizer.

So basically when you have to ask, you shouldn't be using hints. Wink

[Updated on: Fri, 30 September 2011 07:08]

Report message to a moderator

Previous Topic: ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], []
Goto Forum:

Current Time: Fri Jan 30 00:29:57 CST 2015

Total time taken to generate the page: 0.08906 seconds