Re: delete five BIG tables and insert new records on same tables

From: Access <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Tue, 16 Nov 2004 20:04:50 +0100
Message-ID: <419a4f55$0$18205$ba620e4c@news.skynet.be>

"Christine" <karistom_at_hotmail.com> wrote in message news:693b7163.0411151729.368d11e7_at_posting.google.com...
> One more tip.
>
> before you insert lots of data, delete Index/Constraints.
> after finishing data insert, recreate Index/Constraints.
>
> (It may take long time to recreate Index/Constraints.)
>

And recreate the indexes in parallel if you have multiple CPU's. This will speed up index creation quite a bit.
Don't forget to compute index statistics after you removed them (if you are using CBO).

HTH,
Matthias Hoys Received on Tue Nov 16 2004 - 13:04:50 CST