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: Inserting IS Very Very Slow - Why?

Re: Inserting IS Very Very Slow - Why?

From: Madhuri Bannai <bannai_at_prodigy.net>
Date: 2000/03/15
Message-ID: <8apcga$2bp0$1@newssvr04-int.news.prodigy.com>#1/1 







If you trust the data and have the luxury of dropping off the baggage such
as indexes and FK constraints, that may be an idea to make the load happen
faster.



You can enable the constraints later. Also try setting the transaction to
nologging. Again if you can trust the data and have the ability to start all
over again.
Received on Wed Mar 15 2000 - 00:00:00 CST












Original text of this message













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