Truncate Vs Delete

If a table contains 2 million rows, consider the below scenarios?
- DELETE command to delete just few rows in a 2 million row table.
- TRUNCATE command (will obviously deletes 2 million rows)
Which is faster. Truncate or Delete?

Showing Answers 1 - 3 of 3 Answers

Mayur

  • Jan 25th, 2017
 

Truncate will be faster as there is no condition to check however with delete it will go through the 2 million records to find which ones fit the condition.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions