title: how to optimize a left join query?
body: <p>I have two tables, jos_eimcart_customers_addresses and jos_eimcart_customers. I want to pull all records from the customers table, and include address information where available from the addresses table. The query does work, but on my localhost machine it took over a minute to run. On localhost, the tables are about 8000 rows each, but in production the tables could have upwards of 25,000 rows each. Is there any way to optimize this so it doesn't take as long? Both tables have an index on the id field, which is primary key. Is there some other index I need to create that would help this run faster? Should the addresses table have an index on the customer_id field, since it's a foreign key? I have other database queries that are similar and run on much larger tables, more quickly.</p>
  
  <p>(EDITED TO ADD: There can be more than one address record per customer, so customer_id is not a unique value in the addresses table.)</p>
  
  <pre><code>select 
      c.firstname,
      c.lastname,
      c.email as customer_email, 
      a.email as address_email,
      c.phone as customer_phone,
      a.phone as address_phone,
      a.company,
      a.address1,
      a.address2,
      a.city,
      a.state,a.zip, 
      c.last_signin
  from jos_eimcart_customers c
      left join  jos_eimcart_customers_addresses a  
      on c.id = a.customer_id  
  order by c.last_signin desc
  </code></pre>
  
  <p>EDITED TO ADD: Explain results</p>
  
  <pre><code>id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra
  ==========================================================================================
  1  | SIMPLE      |  c    |  ALL |   NULL        | NULL| NULL    |NULL |6175  |Using temporary; Using filesort
  ---------------------------------------------------------------------------------------
  1  | SIMPLE      |  a    |  ALL |   NULL        | NULL| NULL    |NULL |8111  |
  </code></pre>