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 -> Indexing Problem

Indexing Problem

From: Susanth Sivaram <susanths_at_hotmail.com>
Date: 6 Apr 2004 09:59:39 -0700
Message-ID: <f90507d8.0404060859.57ccfb09@posting.google.com>


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.

Thanks,
Susanth. Received on Tue Apr 06 2004 - 11:59:39 CDT

Original text of this message

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