Hi there,Why do you believe the indexes need rebuilding? Just because they have a height of 4?
We have a number of indexes with a height of 3+ which
Yep, indexes are segments, and the segment advisor predicts space reclaimation from an index rebuild. Chris Foot, author of the "OCP Instructors Guide for Oracle DBA Certification", has these notes on the 10g segment advisor output:Segment advisor, recommends for index rebuilding?
In my experience, that's not always true at all!Your indexes will never be used by the cbo if the clustering factor found in dba_indexes is almost equal to or greater than the amount of rows in the table.