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