rebuilding indexes

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,

your index may just grow with table, but not much delete. so you see index extent increase and no rebuild is nessary. you only need to rebuild index when deleted rows is more than 20% of total rows.

If your indexed column is using a sequence, then the index will grow on one side. In that case, you need to rebuild the index once in 3 months, so that the number of look ups in the B-Tree will be decreased.