title: Performance of Oracle Database Link
body: <p>I have two databases <code>A</code> and <code>B</code>. My application runs on Database <code>A</code>. Now I must retrieve some data from database <code>B</code>. Therefore I created a database link to <code>B</code>.</p>
  
  <p>I am wondering what is faster:</p>
  
  <ol>
  <li>Create a View with the corresponding select on database <code>B</code> and get the data via this view:
  <code>select * from myview@B</code></li>
  <li>Select tables directly:
  <code>select * from table1@B, table2@B left outer join table3@B</code>...</li>
  </ol>