Re: Rule Based Optimization Going Away?

I'm doing a full day tutorial on how the Cost Based Optimizer works at UKOUG this year - you might enjoy it, it's six solid hours of CBO - and it might give you some important clues.

It's a relatively small charge if you are already a member of the UKOUG.

I'm also planning to take it out on the road next year, as the class size at UKOUG will be very small.

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





Adrian Bowen wrote in message ...


>Thanks for the update. It sounds like 'bind variable peeking' might help my

>situation, it certainly sounds more promising than the 'hard-coded' value

>distribution assumption made in V8. Basically all I'm trying to do is

>control the order in which multi-table joins are evaluated, based on my

>knowledge of the nature of  the data.

>

>Adrian Bowen

>