1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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