Re: Compressed Indexes and insert operations

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

Sam

On Apr 5, 10:21 am, DA Morgan <damor..._at_psoug.org> wrote:
> oracleing..._at_yahoo.com 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.http://tahiti.oracle.com.
> --
> Daniel A. Morgan
> Oracle Ace Director & Instructor
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org
Received on Mon Apr 07 2008 - 12:54:07 CDT