Re: Compressed Indexes and insert operations

oracleingres_at_yahoo.com wrote:
> Hi
>
> Will there be a performance impact in insert operations in a table
> that has all indexes defined as compressed as opposed to having a
> regular non-compressed index. 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
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org