Multiple choice technology databases

Truncate is faster than delete

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

TRUNCATE is faster than DELETE because TRUNCATE deallocates data pages without logging individual row deletions. DELETE logs each row deletion, making it slower for large tables. TRUNCATE is a DDL operation, while DELETE is DML.

Keep practicing — related questions