Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

MERGE statement - WHEN NOT MATCHED DELETE takes ages Expand / Collapse
Author
Message
Posted Monday, July 22, 2013 4:49 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, July 17, 2014 8:04 AM
Points: 179, Visits: 635
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.
Post #1475935
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse