Index compression on Oracle 9.2

From: Luc Demanche <lucdemanche_at_gmail.com>
Date: Tue, 31 Jan 2006 10:14:43 -0500
Message-ID: <4b3687720601310714l5b7a3c59r8e1b0d8d11e75776@mail.gmail.com>

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Jan 31 2006 - 09:14:43 CST