title: Performance of Inner Join vs Cartesian product
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/44917/explicit-vs-implicit-sql-joins">Explicit vs implicit SQL joins</a>  </p>
  </blockquote>
  
  
  
  <p>I want to know the difference in performance of</p>
  
  <pre><code>select * from A,B,C where A.x = B.y and B.y = C.z
  </code></pre>
  
  <p>and</p>
  
  <pre><code>select * from A INNER JOIN B on A.x = B.y INNER JOIN C on B.y = C.z
  </code></pre>
  
  <p>Basically i want to know if inner join performs better than cartesian product?
  Also, in inner join is cartesian product carried out internally?</p>