1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Which one is faster DELETE/TRUNCATE?

Discussion in 'SQL Server' started by premchandra, Oct 9, 2013.

  1. premchandra

    premchandra Banned

    Joined:
    Sep 28, 2013
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    Which one is faster DELETE/TRUNCATE?
     
  2. KiMO

    KiMO New Member

    Joined:
    Aug 24, 2011
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    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.
     

Share This Page