Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Indexing Problem

Re: Indexing Problem

From: Lemming <thiswillbounce_at_bumblbee.demon.co.uk>
Date: Tue, 06 Apr 2004 18:09:40 +0100
Message-ID: <huo570t3n1tfi34h8shbku3ribc2j3g188@4ax.com>


On 6 Apr 2004 09:59:39 -0700, susanths_at_hotmail.com (Susanth Sivaram) wrote:

>Hi,
>I have a table which has 9 indexes. With 9 indexes, inserting takes a
>lot of time. It takes around 57 minutes for inserting. For the same
>number of records with out indexes, it takes 44 seconds. This large
>time difference in inserting, reduces the performance of the system.
>Pls help in getting around with this problem.

Have you tried dropping the indexes before inserting, doing the batch of inserts and then recreating the index?

Lemming

-- 
Curiosity *may* have killed Schrodinger's cat.
Received on Tue Apr 06 2004 - 12:09:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US