What is difference between truncate and delete command in SQL or when to use truncate vs delete is one of the most frequently asked SQL interview question. Knowledge of this critical command is not only useful on interviews, but also working in database, especially while writing SQL scripts for purging transaction databases. An Incorrect choice of command can result is either very slow process or can even blew up log segment, if too much data needs to be removed and log segment is not enough. That's why it's critical to know when to use truncate and delete command in SQL. In this article, we will first see few differences between them, and based upon them, we should be able to find out when DELETE is better option for removing data or TRUNCATE should be used to purge tables.
Previous Topic
