What is the difference between truncate and delete in pl/sql

test · Posted on 3/22/2015 8:58:17 AM

TRUNCATE TABLE is functionally identical to a DELETE statement without a WHERE clause: both delete all rows in the table. However, TRUNCATE TABLE is faster than DELETE and uses fewer system and transaction log resources. DELETE statement deletes one row at a time and records one item in the transaction log for each row deleted.
TRUNCATE TABLE deletes data by releasing the data pages used to store the table data, and only records the release of the pages in the transaction log.
TRUNCATE, DELETE, DROP are put together to compare:
TRUNCATE TABLE: Deletes content, frees up space but does not delete definitions.
DELETE TABLE: Deleting content does not delete the definition or free up space.
DROP TABLE: Delete content and definitions to free up space.

Using truncate to delete rows in a table is not possible to roll back!

[Source] What is the difference between truncate and delete in pl/sql

Related Posts