Which one is faster DELETE/TRUNCATE?

premchandra's Avatar
Banned
Which one is faster DELETE/TRUNCATE?
0
KiMO's Avatar, Join Date: Aug 2011
Newbie Member
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.