title: Speeding up inner joins between a large table and a small table
body: <p>This may be a silly question, but it may shed some light on how joins work internally.</p>
  
  <p>Let's say I have a large table <code>L</code> and a small table <code>S</code> (100K rows vs. 100 rows).</p>
  
  <p>Would there be any difference in terms of speed between the following two options?:</p>
  
  <pre><code>OPTION 1:                 OPTION 2:
  ---------                 ---------
  SELECT *                  SELECT *
  FROM L INNER JOIN S       FROM S INNER JOIN L
  ON L.id = S.id;           ON L.id = S.id;
  </code></pre>
  
  <p>Notice that the only difference is the order in which the tables are joined.</p>
  
  <p>I realize performance may vary between different SQL languages. If so, how would MySQL compare to Access?</p>