The difference between delete and truncate

Delete differs from truncate:

1) Truncate is a DDL statement, and delete is a DML statement;

2) Truncate speed is much faster than delete;

The reason is that when we perform a delete operation, all table data is copied to the rollback table space first, and the amount of data varies over time. While truncate is directly deleted data does not go into the rollback table space, which results in the delete data we can run rollback for data rollback, and truncate is permanently deleted cannot rollback;

3) The truncate operation does not touch the delete trigger on the publication, and delete will trigger normally;

4) Truncate statement cannot take a where condition means that only all data can be deleted, and delete can delete some data;

5) The TRUNCATE operation resets the table's high watermark (higher water Mark), and delete does not.

The difference between delete and truncate