title: Mysql partitioning and joins
body: <p>Sorry if this is a stupid question but new to this so need some help to understand a couple of things. Im currently upgrading mysql to 5.1 so I can use partitions in mysql. My question is if I partition a table, would a partitioned table, including the pruning process, still work on a quering using a join or is partitioning optimal if your just quering the table that has the partitions?</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>Here is an example query:</p>
  
  <pre><code>SELECT event.*,site.* FROM event INNER JOIN site ON event.siteid = site.id
  WHERE event.eventdate &gt;= [somedate] AND event.eventdate &lt;= [somedate]
  AND event.siteid = [siteid]
  </code></pre>
  
  <p>And I have partitions setup on the events table using the eventdate field. Would mysql still be able to use the partitions on the events table including the pruning process?</p>