RE: Index compression on Oracle 9.2
- From: "Jesse, Rich" <Rich.Jesse@xxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 31 Jan 2006 09:23:16 -0600
Read up on MetaLink about it. I had looked into it too for some GB
indexes, but I seem to remember that most/all of the ONLINE options no
longer work, plus there'll be obvious CPU usage because it'll need to
uncompress for every read and compress for every write. The few GBs of
storage to be saved (in our case, a max of 1 GB) wasn't worth the hassle
to me. YMMV
GL!
Rich
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Luc Demanche
Sent: Tuesday, January 31, 2006 9:15 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Index compression on Oracle 9.2
Hi,
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.
Thanks
Luc
--
Luc Demanche
Oracle DBA
(514) 867-9977
Other related posts:
