Re: slow query - index usage question

From: Telemachus <telemachus_at_ulysseswillreturn.net>
Date: Thu, 20 Mar 2003 10:23:14 -0000
Message-ID: <nEgea.3713$pK2.4111@news.indigo.ie>

I couldn't find that post Howard which you posted but I had read it...so that's why I warned Holger about quoting - even though he was right about what tom said.

I knew that JL had said this, and that ALSO TK had said the other. BUT I don't want to get in the middle.

My own opinion is they're directives as to which choice to take iff a choice exists. Otherwise how could plan stability in stored outlines be guaranteed ?
"Howard J. Rogers" <howardjr2000@
> Quote on:
>
> "Hints" are directives.
>
> There are bugs around., and there are plenty
> of reasons why the hints given are deemed
> to be irrelevant (the smarter the CBO gets,
> the more precise your hinting has to be).
>
> A hint basically says:
> IF you are about to take action X
> then the only option you have is Y
>
> This can be confirmed by reviewing
> 10053 trace files.
>
> However, Oracle is often capable of avoiding
> action X and therefore appears to have ignored
> the hint.
>
> Quote Off.
>
> Regards
> HJR
>
>
>
Received on Thu Mar 20 2003 - 04:23:14 CST