Home Forums SQL Server 2008 SQL Server 2008 - General MERGE statement - WHEN NOT MATCHED DELETE takes ages RE: MERGE statement - WHEN NOT MATCHED DELETE takes ages

  • July 22, 2013 at 4:49 am

    #1634398

    Matthew Darwin (7/22/2013)

    Can you post your DDL also?

    I found the issue the join in the TARGET on sku and giftsku was slowing it down.

    I changed the joining column and it has improved performance greatly. 😀