Re: Delete vs. truncate

From: Nisar Tareen <ntareen_at_attcanada.net>
Date: Tue, 22 Jun 1999 22:41:33 GMT
Message-ID: <xiUb3.71$0L4.397@tundra.ops.attcanada.net>

hi,

Delete and Truncate for in broad term do the same, but deep down they are different.

If you wish to delete or remove or zap all the data from the table than Truncate is the best option, Yes you can achieve this by delete, but by Truncate the Counter of Table No of record is moved up and for delete, it physically go and delete all records, all the element are in use, redo log, rollback segment, db writer and so on, so it is slow.

Good Luck.

Nisar Tareen
Canada...
ntareen_at_allianz.ca

<shuchi_at_my-deja.com> wrote in message news:7kos5p$jh3$1_at_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 - 17:41:33 CDT