DDL is always and always faster than DML.
After firing DDL statement we cannot fire rollback command, but in DML we can.
The reason being for DML; Oracle stores records in Redo Log Files; and copies them back during rollback.
For DDL statements; Log Files are not maintained.
One common question always asked is this -> What is the difference between Delete and Truncate?
Difference 1: Truncate (DDL) is faster than Delete (DML)
Difference 2: Delete can be rollbacked whereas Truncate can't.
Reason being Redo Log Files not maintained for Truncate.
After firing DDL statement we cannot fire rollback command, but in DML we can.
The reason being for DML; Oracle stores records in Redo Log Files; and copies them back during rollback.
For DDL statements; Log Files are not maintained.
One common question always asked is this -> What is the difference between Delete and Truncate?
Difference 1: Truncate (DDL) is faster than Delete (DML)
Difference 2: Delete can be rollbacked whereas Truncate can't.
Reason being Redo Log Files not maintained for Truncate.
No comments:
Post a Comment