Re: More on dbms_stats

Thanks Charu,

I hadn't been aware of this (maybe because I have so few histograms and so rarely rebuild indexes ;-) ).

As I side-note, that is fixed in Oracle 10, which is probably a good thing since there "compute statistics" is done implicitly on an index create or rebuild.

Charu Joshi wrote: 
Just be aware of the side-effect that the compute statistics clause will
wipe out any histogram on the column(s) on which index is being
created/rebuilt (atleast as of 9i).

Regards,
Charu

--
Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com
--
http://www.freelists.org/webpage/oracle-l

Other related posts: