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:
analyze index BOB.PK_NEWSTABLE validate structure;
SQL> select name,btree_space,used_space,pct_used from index_stats;