Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Rule Based Optimization Going Away?

Re: Rule Based Optimization Going Away?

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 3 Oct 2002 23:35:07 -0500
Message-ID: <uadluk5th.fsf@hotpop.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US