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

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


Thanks...
Re: Oracle Hints [message #525259 is a reply to message #525255] Fri, 30 September 2011 07:08 Go to previous message
ThomasG
Messages: 3083
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], [], [], [], [], [], [], []
Next Topic: ORACLE_HOME
Goto Forum:
  


Current Time: Mon Jul 14 04:32:59 CDT 2014

Total time taken to generate the page: 0.18122 seconds