title: What is the significance of the order of statements in mysql explain output?
body: <p>This is mysql explain plan for one of the query I am looking into.</p>
  
  <pre><code>+----+-------------+--------+-------+---------------+---------+---------+------+------+-------+
  | id | select_type | table  | type  | possible_keys | key     | key_len | ref  | rows | Extra |
  +----+-------------+--------+-------+---------------+---------+---------+------+------+-------+
  |  1 | SIMPLE      | table2 | index | NULL          | PRIMARY | 4       | NULL |    6 |       | 
  |  1 | SIMPLE      | table3 | ALL   | NULL          | NULL    | NULL    | NULL |   23 |       | 
  |  1 | SIMPLE      | table1 | ALL   | NULL          | NULL    | NULL    | NULL |    8 |       | 
  |  1 | SIMPLE      | table5 | index | NULL          | PRIMARY | 4       | NULL |    1 |       | 
  +----+-------------+--------+-------+---------------+---------+---------+------+------+-------+
  </code></pre>
  
  <p>4 rows in set (0 sec)</p>
  
  <p>What is the significance of the order of statements in this output ?
  Does it mean that table5 is read before all others ?</p>