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