Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Index compression on Oracle 9.2
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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 31 2006 - 13:13:39 CST
![]() |
![]() |