Improve query Duration
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.