Compare the Difference Between Similar Terms

Difference Between

Home /Archives for transaction log

Difference Between Delete and Truncate

Posted by

删除vs截断SQL (Structure Query Language) commands, Delete and Truncate are used to get rid of data stored in tables in a database. Delete is a DML (Data Manipulation Language) statement and it removes some or all the rows of a table. The ‘Where clause’ is used to specify the rows that are […]

Difference Between Deferred Update and Immediate Update

Posted by

Deferred Update vs Immediate Update Deferred Update and Immediate Update are two techniques used to maintain transaction log files of Database Management Systems (DBMS). Transaction log (also referred to as the journal log or the redo log) is a physical file that stores the Transaction ID, the time stamp of the transaction, the old value […]