Re: Index compression on Oracle 9.2

  • From: Juan Carlos Reyes Pacheco <juancarlosreyesp@xxxxxxxxx>
  • To: j.velikanovs@xxxxxxxxx
  • Date: Tue, 31 Jan 2006 15:13:39 -0400

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


Other related posts: