Re: Compute Statistics during Index Creation

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 1 Feb 2006 22:13:34 +0000 (UTC)
Message-ID: <drrbqe$m59$1@nwrdmz01.dmz.ncs.ea.ibs-infra.bt.com>

"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 2006

Received on Wed Feb 01 2006 - 16:13:34 CST