Index compression on Oracle 9.2

  • From: Luc Demanche <lucdemanche@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 31 Jan 2006 10:14:43 -0500


Oracle 9.2

We are looking to use the index compression.
We have a table of 18Gigs of data, contening 42 millions of rows.

One of the index is 19Gig, another one 17 Gigs, and so on ....

We are looking to reduce the space used by the indexes, but all of the
indexes are important.

Will the compression on the indexes will help us ?  Do you have good/bad
stories about that.


Luc Demanche
Oracle DBA
(514) 867-9977

Other related posts: