Re: Rule Based Optimization Going Away?

This isn't the way it works - although there are a couple of funny undocumented hints for which this is approximately true.

If you make use of the 10053 trace, you will be able to see that the general strategy is that at each point in its processing, Oracle says:

I am about to do X, is there a hint telling me what I MUST do at this point (and, implicitly, what I therefore may NOT do).

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )

____USA__________November 7/9   (Detroit)
____USA__________November 19/21 (Dallas)
____England______November 12/14

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html





Galen Boyer wrote in message ...


>On Thu, 3 Oct 2002, jonathan_at_jlcomp.demon.co.uk wrote:

>

>I thought a hint lowered the percieved "cost" for a particular access

>path and Oracle, therefore, might choose my "hinted" path.

>