rebuild index?

Hello:

I am looking into what factors require me to rebuild the indexes on my databases for Oracle 8.0.4 on NT 4. Aside from too small extents and 'browning'(where deletes leave too many holes in the b_tree structure), I have come across an interesting statistic.

For the analyze valaidate structure process on indexes the index_stats table has two columns whose values determine if a particular index needs to be rebuild:

1. pct_used < 50%
2. blks_gets_per_access > 5.

Has any one come across these statistics? Are they correct?

Are there any other factors to determine when to rebuild indexes?

Any information that can be provided will be greatly appreciated. THanks.

David Spaisman Received on Tue Jun 15 1999 - 12:56:02 CDT