Delete vs. Truncate table.

Posted by

To view Verified answers click on the button below.

Delete logs the deletion of each row whereas Truncate doesn’t log deleted rows in the
transaction log. This makes truncate command is bit faster than Delete command.