Don't forget to analyze the index to see the oracle suggested compression select opt_cmpr_count,opt_cmpr_pctsave from index_stats , to set compression to the maximum can cause to get a bigger index, and I say biiiiiigeeeerr -- //www.freelists.org/webpage/oracle-l