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 -> CREATE INDEX.. COMPUTE STATT.. changes table stats

CREATE INDEX.. COMPUTE STATT.. changes table stats

From: maks <maks70_at_comcast.net>
Date: 18 Feb 2005 14:56:25 -0800
Message-ID: <1108767385.361719.61000@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 Fri Feb 18 2005 - 16:56:25 CST

Original text of this message

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