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