SQL> validate index SCHEMA_NAME.INDEX_NAME;
Index analyzed.
SQL> select opt_cmpr_count, opt_cmpr_pctsave from index_stats where name = ‘INDEX_NAME’;
OPT_CMPR_COUNT OPT_CMPR_PCTSAVE
2 39
16 Friday Mar 2012
Posted Performance
inSQL> validate index SCHEMA_NAME.INDEX_NAME;
Index analyzed.
SQL> select opt_cmpr_count, opt_cmpr_pctsave from index_stats where name = ‘INDEX_NAME’;
OPT_CMPR_COUNT OPT_CMPR_PCTSAVE
2 39