title: Increase performance of Remote Scan
body: <p>I have a SQL Server query looking something like this:</p>
  
  <pre><code>  UPDATE T1
    SET PersonID  = 'L0299'
    FROM [RemoteIP].MyDB1.dbo.Persons P 
         INNER JOIN Inserted I ON P.ID = I.ID
         INNER JOIN [RemoteIP].MyDB1.dbo.Departments D ON D.DepID = I.DepID
    WHERE EventTime &gt;= '2014-08-13' 
  </code></pre>
  
  <p>The basic idea is that when I update a record in a local table, it should update records in a remote table.
  Problem is, this query is slow.  Takes about 2 min 20s from SSMS.</p>
  
  <p>Persons table have 300K records and Departments have 300 records.</p>
  
  <p>Execution plan looks like this:
  <img src="https://i.stack.imgur.com/xsye0.png" alt="enter image description here"></p>
  
  <p>So, the problem is the Remote Scan on table Persons.
  The pop up on Remote Scan looks like this:
  <img src="https://i.stack.imgur.com/dQ3Vh.png" alt="enter image description here"></p>
  
  <p>Any suggestions on how to improve performance?
  I have statistics turned on with indexes on all fields that are used in the joins.</p>