What is the performance of "Merge" clause in sql server 2008?
        Posted  
        
            by ziang
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by ziang
        
        
        
        Published on 2010-03-30T20:03:51Z
        Indexed on 
            2010/03/30
            20:13 UTC
        
        
        Read the original article
        Hit count: 246
        
sql-server-2008
Hi, Merge can performs insert, update, or delete operations on a target table based on the results of a join with a source table. For example, you can synchronize two tables by inserting, updating, or deleting rows in one table based on differences found in the other table.
Is anyone familiar with the performance to use "Merge" versus the traditional logic to check existence and decide the update or insert then?
Thanks!
© Stack Overflow or respective owner