Re: How to speed up dataprocessing?

Wei Chen <wei.chen_at_gzs.de> wrote in message news:<3B934B7D.D160547B_at_gzs.de>...
> I am going to insert a huge data into tables. I've tryed to drop the
> index (PK) first and insert the
> data, then re-create the index(PK). But it seems
> not so much faster than without dropping the index
> when I insert data, but it seems much faster when I
> delete data from tables. Why? Is there any better
> way to speed up the insert-processing?

1. can you give me some more details.(i.e how you are inserting,how manu rows etc.)

Thanks Received on Mon Sep 03 2001 - 20:39:35 CDT