Re: Statistics during a complex load

From: John Hurley <>
Date: Sun, 20 Feb 2011 14:00:49 -0800 (PST)
Message-ID: <>


# I've probably missed something, otherwise there would be a very simple solution: drop all constraints (eg. foreign keys) and indexes before the load, and, if necessary, create them afterwards.  That's always been the fastest way to load data.

Works well for non partitioned tables and you have the option of dropping or just disabling the foreign keys depending on exactly how they were setup initially.

Of course if you need concurrent access to the table(s) while loading it gets more involved. Typically I would consider getting all the stuff into a staging table ...

The volume of data and the timing of handling changes to it is critical to coming up with a complete understanding of what might potentially work. Received on Sun Feb 20 2011 - 16:00:49 CST

Original text of this message