Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Compute Statistics during Index Creation
<bdbafh_at_gmail.com> wrote in message
news:1138926400.368979.272670_at_f14g2000cwb.googlegroups.com...
> Mark,
>
> I saw that one just today in the 10g upgrade guide on page 5-4.
> Now to try to figure out what options its using regarding estimate,
> histograms, etc.
>
> -bdbafh
>
It needn't do anything - it's only produce the figures for user_indexes (et. al.). Although, if you used the option in some versions 9.2, it would neatly destroy any statistics (including histograms) on the first column of the index.
-- Regards Jonathan Lewis http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html Cost Based Oracle: Fundamentals http://www.jlcomp.demon.co.uk/appearances.html Public Appearances - schedule updated 10th Jan 2006Received on Fri Feb 03 2006 - 01:58:14 CST