Re: Slow deleting records

From: Alan D. Mills <alanm_at_uk.europe.mcd.mot.com>
Date: Tue, 3 Nov 1998 11:24:42 -0000
Message-ID: <71mp44$gh2$1@schbbs.mot.com>

Certainly TRUNCATE TABLE tablename is your fastest mechanism for clearing the whole table but if your delete is taking so long then I wonder if any referential integrity rules or database triggers are cutting in to cascade the delete down to child tables or whatever. If so I'm not sure if TRUNCATE will do this or not.

Does use of TRUNCATE fire database triggers and referential integrity rules? I'd be interested to know if anyone knows for sure. Something to consider though, when clearing out your data.

--
Alan D. Mills

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 - 05:24:42 CST