Re: Slow deleting records

From: Joachim Carlsson <joachim.carlsson_at_neurope.ikea.com>
Date: 1998/11/03
Message-ID: <71mfjp$i8t$1@mailgate.ikea.com>#1/1

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 CST