Truncate and Delete concept

Delete would leave "log" statements about every deleted thing and truncate wont. Hence truncate would be faster.

Delete would leave "log" statements about every deleted thing and truncate wont. Hence truncate would be faster.

Detelet is basically used to remove the data from db or from table
but truncate is used to remove data with structure of table.

1.We can filter data in delete but in truncate we cant
2.Truncate faster than delete;
3.We can rollback delete but truncate is auto commit.
4.Delete is DML but truncate is DDL.

Truncate will not delete the structure of the table. That retains the table, but delete every row. The "DROP" command, will delete everything including the structure

- Truncate faster than delete;
- Truncate apply of whole table but one can filter the records in delete command
- We can rollback delete but truncate is auto commit, Once the data has been truncated the data could not be recovered
- Delete is DML but truncate is DDL.