title: Need tips for optimizing SQL Query using a JOIN
body: <p>The Query I'm writing runs fine when looking at the past few days, once I go over a week it crawls (~20min). I am joining 3 tables together. I was wondering what things I should look for to make this run faster. I don't really know what other information is needed for the post.</p>
  
  <p>EDIT: More info: db is Sybase 10. Query:</p>
  
  <pre><code>SELECT a.id, a.date, a.time, a.signal, a.noise,
  b.signal_strength, b.base_id, b.firmware,
  a.site, b.active, a.table_key_id
  FROM adminuser.station AS a
  JOIN adminuser.base AS b
  ON a.id = b.base_id
  WHERE a.site = 1234 AND a.date &gt;= '2009-03-20'
  </code></pre>
  
  <p>I also took out the 3rd JOIN and it still runs extremely slow. Should I try another JOIN method?</p>