Re: Index management

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Tue, 11 May 2004 21:14:38 +1000
Message-ID: <40a0b8d1$1$25007$afc38c87@news.optusnet.com.au>

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:409facd7$0$20512$ed9e5944_at_reading.news.pipex.net...

> 1. Ratio of DBA_INDEXES.CLUSTERING_FACTOR/(DBA_TABLES.NUM_BLOCKS -
> DBA_TABLES.EMPTY_BLOCKS)
> This cannot ever be changed by ALTER INDEX ... REBUILD all 3 components
> refer to the table not the index. There is no way that
> this makes sense for a guidline I'm afraid. Your good indexes after 'fixing'
> will have the same ratio they did before you fixed them and thus will be
> candidates for fixing again.

bzzzzt: you missed the whole purpose of the ratio. Revenue generation.

-- 
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam

Received on Tue May 11 2004 - 06:14:38 CDT