Oh! I sorta created one because it was suggested for good performance of merge in https://technet.microsoft.com/en-us/library/cc879317%28v=sql.105%29.aspx.

i.e. to have a clustered index in target.

I could drop it and try...

Hi , I know this post is very old but could you let me know how did you manage do a merge insert update within seconds.

My source table has only...