Re: More on dbms_stats
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: joshic@xxxxxxxxxxxxxx
- Date: Thu, 11 Aug 2005 07:15:51 -0600
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
--
//www.freelists.org/webpage/oracle-l
Other related posts: