Re: RULE vs. COST OPTIMIZATION & STATIS

BobNight (bobnight_at_aol.com) wrote:
: My understanding is that when Oracle starts working with objects that have
: had analyze stats run against them, it assumes all objects were analyzed
: and thus uses cost based.

my understanding is it only does cost based if you ask it to. this is the default setting on installing V7.
so you might be running merrily along, then analyse a table, and it all comes to a grinding halt, since not all objects were analysed. just set it back to rule-based to run like a dream as it did under V6

-- 
                                          vvv
steve corbett                           [ . .]
stevec_at_dcd.wa.gov.au                       |
scorbett_at_perth.dialix.oz.au     _____oOO_______OOo_____