Re: Compressed Indexes and insert operations
Date: Sat, 05 Apr 2008 10:21:03 -0700
> 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.
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.orgReceived on Sat Apr 05 2008 - 12:21:03 CDT