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_at_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 CEST

This message: [ Message body ]
Next message: Guy Harrison: "Re: How to INSERT efficiently? When to COMMIT, When to CREATE INDEXES .."
Previous message: St. John: "Re: ROBUST:Please dont' use it this term."
In reply to: Adam Tadj: "How to INSERT efficiently? When to COMMIT, When to CREATE INDEXES .."
Next in thread: Guy Harrison: "Re: How to INSERT efficiently? When to COMMIT, When to CREATE INDEXES .."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message