Tags

,

Simple but subtle compress implementation for indexes.. Check it out..

validate index OWNER.INDEX_NAME;

SELECT opt_cmpr_count, opt_cmpr_pctsave
FROM index_stats
WHERE name = ‘INDEX_NAME’;