Re: Rule Based Optimization Going Away?

In article <anjn3m$9hs$1$8300dec7_at_news.demon.co.uk>, "Jonathan says...
>

snip
>
>I believe I have seen the actual assumption printed
>in the 9.2 performance guide. (That book is getting
>so good that it's beginning to make me feel redundant).
>

No need to feel redundant Jonathan, While ever there's someone out there who can't RTFM ...

Pete
>
>Sorry, I have received a couple of FAQs - I'll post them
>'real soon now'.
>
>
>--
>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
>
>
>
>Norman Dunbar wrote in message ...
>>
>>I had heard that this was the way of things before 9.2 in that any query
>>using CHOOSE as the optimiser mode and where stats existed on at least
>>one table,, then the stats would be dynamically gathered, used and
>>discarded hence adding a performance overhead. If the same query was run
>>again later, the stats would be gathered dynamically again and so on.
>>
>
>
>

HTH. Additions and corrections welcome.

Pete

SELECT standard_disclaimer, witty_remark FROM company_requirements; Received on Fri Oct 04 2002 - 11:49:13 CDT