Re: Compute Statistics during Index Creation

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 3 Feb 2006 07:58:14 +0000 (UTC)
Message-ID: <drv2em$l3e$1@nwrdmz02.dmz.ncs.ea.ibs-infra.bt.com>

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

Received on Fri Feb 03 2006 - 01:58:14 CST