Why is SQL Truncate faster than Delete
I have heard that truncate is faster than Delete query in SQL, but many often say you should be careful while using Truncate. Can anyone suggest, when to use Truncate and when to use Delete
TRUNCATE TABLE is a DDL command which drops all the data from the Table and recreates the structure. Because of this it is much faster than DELETE, as it doesn't delete the records one by one and logs them as DELETE query does.
DELETE without WHERE is same as TRUNCATE.
Also TRUNCATE doesn't fire any triggers, resulting in much more faster and efficient performance then DELETE.
But if you want to delete some records or want to store deletion logs (usually used for auditing purpose), you should always go for DELETE with WHERE.
Truncate Table Syntax:
TRUNCATE TABLE table_name;Published on 20 MARCH 2022 at 11:48
