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: 196

Filed under:

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

Related posts about sql-server-2008