Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Index compression on Oracle 9.2
Ram, unfortunately I didn't get a chance to compare before/after. It'd
be pretty simple to test, as all tables were multi-million rows, no
indexes, degree of 4 or 8, pctfree of 0. Maybe my raise this year will
include some minutes of free time so I could do cool stuff like this.
:-)
Dave
Dave Herring, DBA
Acxiom Corporation
3333 Finley
Downers Grove, IL 60515
wk: 630.944.4762
<mailto:dherri_at_acxiom.com <mailto:dherri_at_acxiom.com> >
From: Ram K [mailto:lambu999_at_gmail.com]
Sent: Thursday, February 02, 2006 1:46 PM
To: Herring Dave - dherri
Cc: j.velikanovs_at_gmail.com; oracle-l_at_freelists.org
Subject: Re: Index compression on Oracle 9.2
Dave,
Did you notice any performance difference on the compressed tables.ie. Was it taking longer than before because it has to uncompress.
Thanks
If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.
If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system.
Thank You.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 02 2006 - 14:07:45 CST