Path: text.usenetserver.com!out02a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!i7g2000prf.googlegroups.com!not-for-mail
From: oracleingres@yahoo.com
Newsgroups: comp.databases.oracle.server
Subject: Compressed Indexes and insert operations
Date: Fri, 4 Apr 2008 11:34:02 -0700 (PDT)
Organization: http://groups.google.com
Lines: 9
Message-ID: <441f10cc-9c2d-409d-9d78-dbeaa081e65a@i7g2000prf.googlegroups.com>
NNTP-Posting-Host: 69.25.108.3
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1207334042 21952 127.0.0.1 (4 Apr 2008 18:34:02 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 4 Apr 2008 18:34:02 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: i7g2000prf.googlegroups.com; posting-host=69.25.108.3; 
 posting-account=mKareQoAAAAe8OWHkzWSMe28uAZo8STG
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.12) 
 Gecko/20080201 Firefox/2.0.0.12,gzip(gfe),gzip(gfe)
Xref: usenetserver.com comp.databases.oracle.server:443432
X-Received-Date: Fri, 04 Apr 2008 13:34:03 EST (text.usenetserver.com)

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