Re: Using hints- most commonly used?

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.
>

--
http://www.freelists.org/webpage/oracle-l