Re: Index management

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Tue, 11 May 2004 06:42:08 +1000
Message-ID: <409fe914$0$28242$afc38c87@news.optusnet.com.au>

Brian Peasland wrote:

>
> Thanks for providing that. I now know that your clustering factor is the
> same as Oracle's definition, since you are using the CLUSTERING_FACTOR
> column of DBA_INDEXES. And I now fully understand your ratio you have
> been talking about.

And that's it? That's all you have to *say* about this ratio that you now fully understand?

Would you not care to elaborate just a little on how this ratio behaves after an index rebuild?

Regards
HJR Received on Mon May 10 2004 - 15:42:08 CDT