title: Remote query, view and where clause performance
body: <p>I'm a bit puzzled over a performance problem with our SQL server when using remote query's and applying a where clause. When I run the query on the local server a clustered index seek is used, but from remote this is not the case.</p>
  
  <p>So when running this on the local server it will take 2 seconds:</p>
  
  <pre><code>SELECT * FROM uv_order WHERE order_id &gt; '0000200000'
  </code></pre>
  
  <p>But running this from a remote database takes 2 minutes:</p>
  
  <pre><code>SELECT * FROM RemoteServer.data.dbo.uv_order WHERE order_id &gt; '0000200000'
  </code></pre>
  
  <p>Here <code>uv_order</code> is a quite complex view but since an index seek is used when executing from the local server I don't see why it can't use it when running a remote query. This only seams to apply to view since doing the same thing on a table will work as expected.</p>
  
  <p>Any ideas why this happens and how to "fix" it?</p>