title: Oracle SQL Query Filter in JOIN ON vs WHERE
body: <p>For <em>inner joins</em>, is there any difference in performance to apply a filter in the <code>JOIN ON</code> clause or the <code>WHERE</code> clause? Which is going to be more efficient, or will the optimizer render them equal?</p>
  
  <p><strong>JOIN ON</strong></p>
  
  <pre><code>SELECT u.name
  FROM users u
  JOIN departments d
  ON u.department_id = d.id
  AND d.name         = 'IT'
  </code></pre>
  
  <p>VS</p>
  
  <p><strong>WHERE</strong></p>
  
  <pre><code>SELECT u.name
  FROM users u
  JOIN departments d
  ON u.department_id = d.id
  WHERE d.name       = 'IT'
  </code></pre>
  
  <p>Oracle 11gR2</p>