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: How to INSERT efficiently? When to COMMIT, When to CREATE INDEXES ..

Re: How to INSERT efficiently? When to COMMIT, When to CREATE INDEXES ..

From: Dom <semineld_at_icon.co.za>
Date: 1997/05/26
Message-ID: <01bc6a16$696235c0$29dd1ac4@dominique.icon.co.za>#1/1

I never seen any difference in the commit frequency but I did recently some tests with 7.1.4 on Digital and the drop of index prior to hudge inserts is 30 to 50 % faster (I was using Oracle import facility). Received on Mon May 26 1997 - 00:00:00 CDT

Original text of this message

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