Re: Oracle is painfully slow when doing massive INSERTs

From: Morten Myrvold <someone_at_somwehere.no>
Date: 1998/03/12
Message-ID: <6e81ki$798$1@elle.eunet.no>#1/1

Mark Usrey wrote in message <6e6t7j$98d_at_bgtnsc02.worldnet.att.net>...

>You did mention any indices that are kept on you destination table. Large
>amounts
>of time can be spent updating the various indices on the destination table
if
>they are complex. Also, if the rows being inserted are already ordered,
updates
>
>to indices and be particularly slow.
>
>If you are keeping indices, try dropping them before doing the insert, and
then
>recreating them afterwards.

Ah, but I have... (dropped them, I mean). Postponing the creation of the indices until *after* the data had been loaded resulted in a 150-200% performance gain, but it still takes far too long.... ;-) Received on Thu Mar 12 1998 - 00:00:00 CST