Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Rule Based Optimization Going Away?
On Thu, 3 Oct 2002, jonathan_at_jlcomp.demon.co.uk wrote:
>
> "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
I thought a hint lowered the percieved "cost" for a particular access path and Oracle, therefore, might choose my "hinted" path.
-- Galen deForest Boyer Sweet dreams and flying machines in pieces on the ground.Received on Thu Oct 03 2002 - 23:35:07 CDT