Re: Compressed Indexes and insert operations

From: <>
Date: Mon, 7 Apr 2008 10:54:07 -0700 (PDT)
Message-ID: <>

Thanks for all your inputs. I just moved into this opening and getting access to the systems is still in works. But had to look into a performance issue where the host cpu is peaking at 100% almost all day long with this process grinding slowly. My first thought was relating to the compressed indexes( there are 8 indexes on this table) and just wanted some validation.

Thanks again for your inputs


On Apr 5, 10:21 am, DA Morgan <> wrote:
> wrote:
> > Hi
> > Will there be a performance impact in insert operations in a table
> > that has all indexes defined ascompressedas opposed to having a
> > regular non-compressedindex. This is in Oracle 10g.
> > Thanks
> > Sam
> The other responses you have received cover the topic well but I
> would like to address one point in your question.
> There is essentially no chance you are ever going to compress all
> indexes in 10g given the way the compression works. I would
> suggest reading more in Oracle's docs so that you understand how
> they work.
> --
> Daniel A. Morgan
> Oracle Ace Director & Instructor
> University of Washington
> (replace x with u to respond)
> Puget Sound Oracle Users
Received on Mon Apr 07 2008 - 12:54:07 CDT

Original text of this message