Truncate is a DDL operation that removes all rows from a table, while delete is a DML operation that removes specific rows.

• Truncate is faster than delete as it doesn't generate any undo logs or trigge...read more

TRUNCATE should be used when you need to delete all rows from a table and you do not need to be able to restore the deleted rows. DELETE should be used when you need to delete specific rows from a tab...read more