Hi guys,
I ran these two scripts to find out if there are indexes that needs to be rebuid, but there were none. None of the indexes needs rebuilding.

SQL> select index_name, blevel, decode(blevel,0,'OK BLEVEL',1,'OK BLEVEL',
2,'OK BLEVEL',3,'OK BLEVEL',4,'OK BLEVEL','BLEVEL HIGH') OK
from dba_indexes


SQL> select DEL_LF_ROWS*100/decode(LF_ROWS, 0, 1, LF_ROWS) PCT_DELETED,
(LF_ROWS-DISTINCT_KEYS)*100/ decode(LF_ROWS,0,1,LF_ROWS)
DISTINCTIVENESS
from index_stats
where NAME='&index_name'





But I found out that the extents for the indexes segments are 35.
What do you guys think?


thanks,