One obvious thing to check: If you can afford to do this (i.e. if the
table that you're loading will not be referenced by other processes
duing the load) try dropping all the indexes on your target table, and
recreate them when you're done. Inserting into a table with indexes is
much slower than one without, and often the cost of a full rebuild
after the fact is much less than paying for the continuous updating of
them during the load, especially if your target table is empty at the
start of the load.
-Steve
Received on Thu Jun 09 2005 - 12:05:08 CDT
