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
--
http://www.freelists.org/webpage/oracle-l
- References:
- RE: Index compression on Oracle 9.2
- From: Jesse, Rich
- Re: Index compression on Oracle 9.2
- From: Jurijs Velikanovs
Other related posts:
- » Index compression on Oracle 9.2
- » RE: Index compression on Oracle 9.2
- » Re: Index compression on Oracle 9.2
- » Re: Index compression on Oracle 9.2
- » Re: Index compression on Oracle 9.2
- » Re: Index compression on Oracle 9.2
- » RE: Index compression on Oracle 9.2
- » RE: Index compression on Oracle 9.2
- » Re: Index compression on Oracle 9.2
- » RE: Index compression on Oracle 9.2
- » Re: Index compression on Oracle 9.2
- » Re: Index compression on Oracle 9.2
- » Re: Index compression on Oracle 9.2
- » Re: Index compression on Oracle 9.2
- » Re: Index compression on Oracle 9.2
- » Re: Index compression on Oracle 9.2
- » RE: Index compression on Oracle 9.2
- » Re: Index compression on Oracle 9.2
- » Re: Index compression on Oracle 9.2
- RE: Index compression on Oracle 9.2
- From: Jesse, Rich
- Re: Index compression on Oracle 9.2
- From: Jurijs Velikanovs