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