Delete vs. truncate

From: <shuchi_at_my-deja.com>
Date: Tue, 22 Jun 1999 20:38:26 GMT
Message-ID: <7kos80$jhj$1@nnrp1.deja.com>

My question is general one regarding purging of data from the database. Are there situations when delete from table is better then truncate table? IF so when.
Which is faster of the two?

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jun 22 1999 - 15:38:26 CDT