My index needs rebuilding so I analyzed it and based on the information from the index_stats, the pct_used was 81% so I decided to rebuild it.
After rebuilding it, I decided to analyze it again to make sure that pct_used column of the index_stats is good. After analyzing it again, Irealized that the pct_used column has not changed.
I thought that after rebuilding the index the pct_used column of index_stats would change. Am I wrong? Or I'm doing something wrong
Below are the steps that I followed:
1.
analyze index BOB.PK_NEWSTABLE validate structure;
2.
SQL> select name,btree_space,used_space,pct_used from index_stats;
NAME BTREE_SPACE USED_SPACE PCT_USED
------------------------------ ----------- ---------- ----------
PK_NEWSTABLE 58532 47046 81
3.
ALTER INDEX BOB.PK_NEWSTABLE REBUILD storage
(initial 4M next 4M pctincrease 0)
tablespace news_ind_tbs;
4.
SQL> analyze index BOB.PK_NEWSTABLE validate structure;
Index analyzed.
5.
SQL> select name,btree_space,used_space,pct_used from index_stats;
NAME BTREE_SPACE USED_SPACE PCT_USED
------------------------------ ----------- ---------- ----------
PK_NEWSTABLE 58532 47010 81