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