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@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 - 11:41:59 CST