SQL> Analyze index MY_INDEX_PK validate structure; Index analyzed. SQL> select NAME, HEIGHT, LF_ROWS, DEL_LF_ROWS from INDEX_STATS; NAME HEIGHT LF_ROWS DEL_LF_ROWS ------------------------------ -------------------------------- -------------------------------- -------------------------------- MY_INDEX_PK 3 38,100,084 2,494,884
ALTER INDEX my_index REBUILD
ALTER INDEX my_index REBUILD NOLOGGING