1Under the hood
If you use 'DELETE FROM users', the database engine scans and deletes every single row one by one, recording each deletion in a transaction log. This is very slow for millions of rows. 'TRUNCATE' ignores the rows and simply deallocates the data pages on the hard drive instantly. Truncate is a lightning-fast wipe.
