Analyze the indexes using
ANALYZE INDEX index_name VALIDATE STRUCTURE;
Then query the INDEX_STATS table and compare LF_ROWS with DEL_LF_ROWS.
if you have > 15% of the rows as deleted, then I'd rebuild the index.
|
Results 1 to 9 of 9
Thread: When to rebuild indexesThreaded View
|
Click Here to Expand Forum to Full Width |