title: Asking for suggestions on database table design base on this described scenario
body: <p>It might be a weird situation, but it just come to my mind...<br>
  Imagine I have a database table which takes 1 million new rows everyday. There are 3 columns in the table: id, value, date.  </p>
  
  <p>What I would like to do with the rows is to load all rows depending on date.</p>
  
  <p>Here comes to the question:  </p>
  
  <p>Given the nature of this table and the way I use it(I only need to grab the list of rows on a specific day), performance wise, does creating a new table with same structure but named with date on daily basis(ie, create table with name 01Jan2014, 02Jan2014, ... each with 1 million records in it) takes advantage over having all rows in one table and date column as index?</p>