| Oracle Hints [message #525255] |
Fri, 30 September 2011 06:50  |
prejib
Messages: 126
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  |
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
prejib wrote on Fri, 30 September 2011 13:50How 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. 
[Updated on: Fri, 30 September 2011 07:08] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
