Home Forums SQL Server 2008 SQL Server 2008 - General Big Performance Problem with Merge Statement RE: Big Performance Problem with Merge Statement
spaghettidba
SSC Guru
Points: 105732
More actions
June 21, 2013 at 9:44 am
#1626385
Also, the plans don't look very similar.
The DELETE plan is way different. It's a parallel plan, while the MERGE plan is serial. There's a hash match and... it's a different plan!
I think most of the magic is in there.
-- Gianluca Sartori