Go4Expert

Go4Expert (http://www.go4expert.com/)
-   SQL Server (http://www.go4expert.com/forums/sql-server-forum/)
-   -   Which one is faster DELETE/TRUNCATE? (http://www.go4expert.com/forums/faster-delete-truncate-t29853/)

premchandra 9Oct2013 18:27

Which one is faster DELETE/TRUNCATE?
 
Which one is faster DELETE/TRUNCATE?

KiMO 10Oct2013 12:41

Re: Which one is faster DELETE/TRUNCATE?
 
TRUNCATE is faster, as it does not actually "deletes" the data, but instead, it marks the extents as empty and free for use. On the other hand, DELETE is a "per row" operation, which actually empties the extents' contents, thus performing slower.


All times are GMT +5.5. The time now is 01:02.