title: Where (implicit inner join) vs. explicit inner join - does it affect indexing?
body: <p>For the query  </p>
  
  <pre><code>SELECT * from table_a, b WHERE table_a.id = b.id AND table_a.status ='success'  
  </code></pre>
  
  <p>or  </p>
  
  <pre><code>SELECT * from a WHERE table_a.status ='success' JOIN b ON table_a.id = b.id
  </code></pre>
  
  <p>Somehow, i would tend to create one index (id,status) on table_a for the top form<br>
  whereas my natural tendency for the bottom form would be to create two separate indices, 
  id, and status, on table_a.</p>
  
  <p>the two queries are effectively the same, right? would you index both the same way?<br>
  how would you index table_a (assuming this is the only query that exists in the system to avoid other considerations)? one or two indices?</p>