you can:
analyze index OWNER.INDEX_NAME validate structure;
OR
validate index OWNER.INTCH1 ;
select * from INDEX_STATS;
I usually look at the height, distinct_keys,
BLKS_GETS_PER_ACCESS, ROWS_PER_KEY etc...
|
Results 1 to 8 of 8
Thread: Index statisticsThreaded View
|
Click Here to Expand Forum to Full Width |