Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: CREATE INDEX.. COMPUTE STATT.. changes table stats

Re: CREATE INDEX.. COMPUTE STATT.. changes table stats

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 19 Feb 2005 17:14:23 +0000 (UTC)
Message-ID: <cv7s5f$li$1@titan.btinternet.com>

Depends on what you mean by "normal".

Yes, it happens in 8.1 and 9.2 - specifically, it's only the histogram on the first column of the index that is deleted, and the column stats get updated.

This is (probably) a bug, and does not happen in 10.1.0.3.

-- 
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/seminar.html
Public Appearances - schedule updated Jan 21st 2005






"maks" <maks70_at_comcast.net> wrote in message 
news:1108767385.361719.61000_at_c13g2000cwb.googlegroups.com...

> Hello,
>
> I just observed that while creating index with "COMPUTE STATISTICS"
> also collect the table/column (for the column in index) level
> statistics.
>
> Is this a normal behaviour?
>
> Problem is , it does not create the histograms for the column which
> eventually make CBO to choose in-correct execution plan...
>
> Maks.
>
Received on Sat Feb 19 2005 - 11:14:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US