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

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.)

"PC" <no_at_spam.com> wrote in message news:<cnalii$855$1_at_msunews.cl.msu.edu>...
> I need to delete five BIG tables and insert new records on same tables.
> Since it involved lot of computing, it will take long. I'm thinking it
> will take probably couple of days.
>
> What I want is minimal down time, if I have to have little down time.
> I have sql insert scripts to run.
>
> Any suggestions?
> Thanks.
> -Jay
Received on Mon Nov 15 2004 - 19:29:49 CST