title: Explicit JOINs vs Implicit joins?
body: <p>My Database Professor told us to use:</p>
  
  <pre><code>SELECT A.a1, B.b1 FROM A, B WHERE A.a2 = B.b2;
  </code></pre>
  
  <p>Rather than:</p>
  
  <pre><code>SELECT A.a1, B.b1 FROM A INNER JOIN B ON A.a2 = B.b2;
  </code></pre>
  
  <p>Supposedly Oracle don't likes JOIN-Syntaxes, because these JOIN-syntaxes are harder to optimize than the WHERE restriction of the Cartesian Product.</p>
  
  <p>I can't imagine why this should be the case. The only Performance issue could be that the parser Needs to parse a few characters more. But that is negligible in my eyes.</p>
  
  <p>I found this Stack Overflow Questions: </p>
  
  <ul>
  <li><a href="https://stackoverflow.com/questions/7810515/is-there-an-oracle-official-recommendation-on-the-use-of-explicit-ansi-joins-vs">Is there an Oracle official recommendation on the use of explicit ANSI JOINs vs implicit joins?</a></li>
  <li><a href="https://stackoverflow.com/questions/44917/explicit-vs-implicit-sql-joins">Explicit vs implicit SQL joins</a></li>
  </ul>
  
  <p>And this sentence in a Oracle Documentation: <a href="https://docs.oracle.com/cd/B19306_01/server.102/b14200/queries006.htm" rel="noreferrer">https://docs.oracle.com/cd/B19306_01/server.102/b14200/queries006.htm</a></p>
  
  <blockquote>
    <p>Oracle recommends that you use the FROM clause OUTER JOIN syntax rather than the Oracle join operator.</p>
  </blockquote>
  
  <p>Can someone give me up-to-date recommendations from Oracle with link. Because she don't acknowledges StackOverflow (here can answer everyone) and the 10g Documentation is outdated in here eyes.  </p>
  
  <p>If i am wrong and Oracle realy don't likes JOINS now than thats also ok, but i don't find articles. I just want to know who is Right.</p>
  
  <p>Thanks a lot to everyone who can help me!</p>