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.

Satalaj

Tags:

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

Author

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 ASP.net 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.