title: SQL 2005 - Linked Server to Oracle Queries Extremely Slow
body: <p>On my SQL 2005 server, I have a linked server connecting to Oracle via the OraOLEDB.Oracle provider.</p>
  
  <p>If I run a query through the 4 part identifier like so:</p>
  
  <pre><code>SELECT * FROM [SERVER]...[TABLE] WHERE COLUMN = 12345
  </code></pre>
  
  <p>It takes over a minute to complete.  If I run the same query like so:</p>
  
  <pre><code>SELECT * FROM OPENQUERY(SERVER, 'SELECT * FROM TABLE WHERE COLUMN = 12345')
  </code></pre>
  
  <p>It completes instantly.  Is there a setting I'm missing somewhere to get the first query to run in a decent period of time?  Or am I stuck using openquery?</p>