Post reply

Which is better option, truncate and load or delete and update

  • August 23, 2011 at 2:40 am

    #142829

    Hi All,

    We have a table of about 25 GB where data is truncated daily and loaded. Few existing data in the table is inserted or updated.

    Which will be a better option, to delete the selected rows and insert the updated values or to truncate the table and load the entire table once again?

    Will the same logic be applicable for smaller tables?

  • August 23, 2011 at 3:02 am

    #1371819

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1163779-391-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply