Re: Migrating to cost based optimizer

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:desdh2hsotkg7ejt30cgndkpdeqrnuqq8o_at_4ax.com...
>>
>> I think it's a good bet that there will always be a few oddities,
>> but if you (or your client) starts with a legacy data load and
>> do proper UAT, then the anomalies and places where the
>> stats need to be adjusted should show up early. But it does
>> help to have an experienced reviewer checking what's going
>> on and predicthing threats.
> =
>
> What would you say about 3rd party maintenance routinely (every day)
> collecting stats, and NOT saving the old stats in a stats table?
>

I would probably say they ought to be doing more for their money.

-- 
Regards

Jonathan Lewis
http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis

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

Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html