delete vs truncate

delete vs truncate

 I deleted 8 million records from one table using delete statement, it tooks 30min to finish the operation.
I truncated same records using Truncate table statement in fraction of second.
Truncate is faster as it has not to check the constrains unlike delete. Truncate will give you fresh copy of table with all seed maaped to its default index.



CSS Padding Vs Margin CSS Margin Vs PaddingLCD Vs LED Vs (Edge Led) Televisions.C# Delete All Files In DirectoryVisual Studio Recover Deleted delete file file on Server and String vs stringC# ref Vs outServerTransfer vs ResponseRedirectDateTime.Today Vs DateTime.NowHttp Vs. HttpsPostback from JavaScript


My name is Satalaj, but people call me Sat. Here is my homepage: . I live in Pune, PN and work as a Software Engineer. I'm former MVP in year 2010.
Disclaimer: Views or opinion expressed here are my personal research and it has nothing to do with my employer. You are free to use the code, ideas/hints in your projects. However, you should not copy and paste my original content to other web sites. Feel free to copy or extend the code.
If you want to fight with me, this website is not for you.

I'm Satalaj.