Re: DELETE vs TRUNCATE
From: Glen A. Stromquist <gstromquist_at_nospamyahoo.com>
Date: Wed, 06 Feb 2002 17:41:59 GMT
Message-ID: <HVd88.68233$M3.10532148_at_news1.telusplanet.net>
Date: Wed, 06 Feb 2002 17:41:59 GMT
Message-ID: <HVd88.68233$M3.10532148_at_news1.telusplanet.net>
Truncate will usually run much faster then delete
Truncate does not use the rollback segment (DDL)
Truncate will not fire any "on delete" triggers
hth
"Stjepan Brbot" <Stjepan.Brbot_at_ZG.HiNet.HR> wrote in message
news:a3rof4$458u$3_at_as201.hinet.hr...
> What is the difference between DELETE and TRUNCATE SQL commands? What's
> about indicies of tables which content is emptied by those commands?
>
> --
>
> Stjepan Brbot <Stjepan.Brbot_at_ZG.HiNet.HR>
>
>
>
Received on Wed Feb 06 2002 - 18:41:59 CET