title: Is there any performance difference between use natural join and set operator intersect?
body: <p>I'm practicing on the standard HR Oracle database and I have doubts about the use of the set operator INTERSECT. I have these situations: </p>
  
  <pre><code>SELECT       employee_id, job_id, department_id
  FROM         employees
  NATURAL JOIN job_history;
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/zieDF.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/zieDF.jpg" alt="NATURAL JOIN Results"></a></p>
  
  <pre><code>SELECT employee_id, job_id, department_id
  FROM   employees 
  INTERSECT
  SELECT employee_id, job_id, department_id 
  FROM   job_history;
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/qKC3g.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qKC3g.jpg" alt="INTERSECT Results"></a></p>
  
  <p>Both statements have the same set of results. Is there any performance difference??? Thanks.</p>