Why use truncate instead of delete?

TRUNCATE TABLE is faster and uses fewer system resources than DELETE , because DELETE scans the table to generate a count of rows that were affected then delete the rows one by one and records an entry in the database log for each deleted row, while TRUNCATE TABLE just delete all the rows without providing any ...

Related posts: