Tags

,

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