Re: Oracle is painfully slow when doing massive INSERTs

Jim

I agree

Another common problem though is that people frequently insert or import into tables with live indexes so that during the insert much time is wasted in doing index sorts after each row is inserted. I've found that by far the best approach is to drop the index (if you can), perform the insert and then recreate the indexes again at the end.

Hope this is of use.

John K Received on Fri Mar 27 1998 - 00:00:00 CST