Home » RDBMS Server » Server Administration » Oracle Hints
Oracle Hints [message #525255] Fri, 30 September 2011 06:50 Go to next message
Messages: 123
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: 3136
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: Sun Nov 29 05:25:17 CST 2015

Total time taken to generate the page: 0.08366 seconds