title: SQL join performance operation order
body: <p>I am trying to come up with how to order a join query to improve its performance.</p>
  <p>Lets say we have two tables to join, to which some filters must be applied.</p>
  <p>Is it the same to do:</p>
  <pre><code>table1_result = select * from table1 where field1 = 'A';
  table2_result = select * from table2 where field1 = 'A';
  
  result = select * from table1 as one inner join table2 as two on one.field1 = two.field1;
  </code></pre>
  <p>to doing this:</p>
  <pre><code>result = select * from table1 as one inner join table2 as two on one.field1 = two.field1
              where one.field1 = 'A' and two.field1 = 'A';
  </code></pre>
  <p>or even doing this:</p>
  <pre><code>result = select * from table1 as one inner join table2 as two on one.field1 = two.field1 and one.field1 = 'A';
  </code></pre>
  <p>Thank you so much!!</p>