title: SQL Server Linked Server to Progress is slow with an openquery view
body: <p>We have a SQL Server database setup with a Linked Server setup connecting to a Progress OpenEdge database. We created a SQL Server view (for using with SSRS) of some of the OpenEdge tables using code similar to the following:</p>
  
  <p>CREATE VIEW accounts AS SELECT * FROM OPENQUERY(myLinkedServerName,
  'SELECT * FROM PUB.accounts')</p>
  
  <p>CREATE VIEW clients AS SELECT * FROM OPENQUERY(myLinkedServerName,
  'SELECT * FROM PUB.clients')</p>
  
  <p>For some reason the queries seem to bring back the whole table and then filter on the SQL side instead of executing the query on the Progress side. </p>
  
  <p>Anybody know why or how to remedy the situation?</p>
  
  <p>Thanks</p>