Re: Slow deleting records

When deleting all records truncate the table

truncate table xxx;

If you want to delete some records > 10 % drop the index if you don't have a very complicated look up.

Regards
/Joachim
Dave's News wrote in message ...
>I have a table that only has 15000+ records but when I try to delete all
 the
>records it takes forever. We benched marked it to about 15 minutes per
 1000
>records. The only thing I can think that may cause this is that this table
>has a long datatype field but most records are very small.
>
>Any ideas would be appreciated.
>
>
Received on Tue Nov 03 1998 - 00:00:00 CET