title: Any advantage in indexing a DATE column?
body: <p>In mysql, is there any benefit to adding an index to a <code>DATE</code> column? I will be using the column for comparisons such as:</p>
  
  <pre><code>SELECT * FROM birthdays WHERE date &gt; today + 3 days;
  </code></pre>
  
  <p>Would indexing the <code>date</code> column improve performance here?</p>