Re: Compressed Indexes and insert operations
Date: Fri, 4 Apr 2008 15:22:53 -0700 (PDT)
Message-ID: <893099bf-92d1-45c6-86e3-aff397cac8f3@l42g2000hsc.googlegroups.com>
On Apr 4, 2:34 pm, oracleing..._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
If you do a little research on your own you will see lots of opinions about this topic. In general there is some additional cpu required but it all depends ... does it cause a problem? Well cases can be constructed on both sides.
I do find it useful at times to compress the top level(s ... sometimes ) of multi-column indexes but you don't include that information in your question.
Do you have adequate space to host your indexes without using any compression? That situation uses the least amount of cpu.
Lots on info on the Tom Kyte site as well as the Jonathan Lewis site. Have you looked at any of those yet? Received on Fri Apr 04 2008 - 17:22:53 CDT