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