Re: Using hints- most commonly used?
- From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
- To: cjnewman@xxxxxxxxxxxxx
- Date: Tue, 09 Sep 2008 17:23:52 +0200
Chris,
This is probably the most useful links about hints:
http://jonathanlewis.wordpress.com/2008/05/02/rules-for-hinting/.
This is a position I share. I used to think that a few hints were
harmless, but I'm no longer so sure.
A few weeks ago, I met an interesting query in which the hint was
contributing to get the proper result (by forcing an index descent). In
other words: remove the hint, you get a wrong result. Isn't it nice?
/*+ Hope_that_helps */
SF
Newman, Christopher wrote:
Does anyone have a link for information on using hints? Specifically,
I'm writing a tuning guide and looking for a minimalist guide of the
most commonly used hints and their usage.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
