Improve query Duration

Mushtaq 2013-06-18 21:28:44


Please find attached actual exec plan of the query which runs in 12 secs. This is processing a single record & updates on remote servers. The problem is it processes one row at a time and with many rows to be processed, 12 secs for each row is very long.

Any suggestion is appreciated and thanks in advance.

GokhanVarol 2013-06-19 01:08:14
Please post actual plan. it would help if you could get the query plan also from the remote site if that is the problem.