Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to judge index health

user8803475Nov 21 2009 — edited Nov 23 2009

Hi
i just want to know how to judge index is healthy
i know i should look at
BLEVEL , LEAF_BLOCKS , DISTINCT_KEYS , CLUSTERING_FACTOR
in dba_indexes

but how to calculate from this value the health of an index

I know that BLEVEL should be 3 or less , any other rules?

Thanks very much

This post has been answered by Hemant K Chitale on Nov 22 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 21 2009

Added on Nov 21 2009

#general-database-discussions

14 comments

4,520 views