title: SQL Server not running queries on remote (Linked MySQL) server
body: <p>For various horrible reasons, we've had to link SQL Server to a MySQL database using Linked Servers and an ODBC Data Source. The queries run fine, but looking at the query plans you can see that SQL Server is always doing a full table scan on the remote server - and then doing any joins/filtering at the SQL Server end.</p>
  
  <p>How can we push these to the MySQL server instead?</p>
  
  <p>Thanks</p>
  
  <p>James</p>