Advanced SQL Developer — Medium
Key points
- TRUNCATE is a DDL operation, DELETE is a DML operation
- TRUNCATE deallocates data pages with minimal logging
- DELETE logs each row individually
- TRUNCATE cannot be filtered with WHERE, DELETE can
- TRUNCATE is faster on large tables
Ready to go further?
Related questions