Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Compute Statistics during Index Creation
"Mark D Powell" <Mark.Powell_at_eds.com> wrote in message
news:1138819530.770159.318640_at_f14g2000cwb.googlegroups.com...
> It is cheap. With 10g alter index rebuilds automatically performs the
> compute and the syntax is being depreciated.
>
> HTH -- Mark D Powell --
>
It would be interesting to check whether 10g uses the algorithm used by dbms_stats.gather_index_stats, or the algorithm used by 'analyze index compute statistics'; They may not give the same results.
-- 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 Wed Feb 01 2006 - 16:13:34 CST