RE: Index compression on Oracle 9.2

From: Jesse, Rich <Rich.Jesse_at_quadtechworld.com>
Date: Tue, 31 Jan 2006 09:23:16 -0600
Message-ID: <FB5D3CCFCECC2948B5DCF4CABDBE6697545D67@QTEX1.qg.com>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Luc Demanche
	Sent: Tuesday, January 31, 2006 9:15 AM
	To: oracle-l_at_freelists.org
	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 

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jan 31 2006 - 09:23:16 CST