Home » RDBMS Server » Server Administration » Oracle Hints
Oracle Hints [message #525255] Fri, 30 September 2011 06:50 Go to next message
Messages: 126
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: 3202
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: important question [merged 3]
Next Topic: ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [], [], [], [], [], [], []
Goto Forum:

Current Time: Sun Aug 20 21:36:35 CDT 2017

Total time taken to generate the page: 0.02433 seconds