Friday, May 20, 2011

Difference Between Truncate And Delete

1)DELETE
Delete is Dml statement
we can use conditions on delete like where clause,
delete keeps record in buffers(temporary storage) till the first rollback or commit
a bit slower
triggers will fire in delete operation

2)TRUNCATE
Truncate is DDL statement
we can't using conditions in truncate
no rollback segments in truncate
much faster than delete
no triggers will fired in truncate

No comments:

Post a Comment