OPT_CMPR_COUNT

all,

there are two columns in the INDEX_STATS view that are not very well documented. they are OPT_CMPR_COUNT and OPT_CMPR_PCTSAVE. from the little documentation that i HAVE seen, it seems these are set when one issues ANALYZE INDEX <index name> VALIDATE STRUCTURE.

 

OPT_CMPR_COUNT appears to the optimal compress count if one should choose to rebuild the index with key compression.

and

OPT_CMPR_PCTSAVE appears to the percentage of disk space that will be saved if the index is rebuilt with key compression, as compared to the indexes current size.

 

question: IS there any DETAILED documentation on these?