Re: Statistics during a complex load
From: Gerard H. Pille <ghp_at_skynet.be>
Date: Sun, 20 Feb 2011 20:35:50 +0100
Message-ID: <4d616d17$0$14248$ba620e4c_at_news.skynet.be>
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. Received on Sun Feb 20 2011 - 13:35:50 CST
Date: Sun, 20 Feb 2011 20:35:50 +0100
Message-ID: <4d616d17$0$14248$ba620e4c_at_news.skynet.be>
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. Received on Sun Feb 20 2011 - 13:35:50 CST