title: What type of index in best for DATE type on Oracle?
body: <p>Basing on your experience with Oracle, what will be the best type and settings for index that you would set on a column of DATE type?</p>
  
  <ul>
  <li>I don't necessarily need to go for partitioned index. </li>
  <li>It is a logging kind of table. </li>
  <li>You don't really care about unique id as a primary key (in fact date is close enough to be uniques most of the time, but due to nature of it, never will be).</li>
  </ul>
  
  <p>Will it be fair to create a cluster index?</p>
  
  <p>What I'm interested in is to optimize execution of queries like SELECT * FROM Log WHERE [Date] > '20-06-2009' ORDER BY [Date] DESC, not slowing down inserts massively.
  (btw. in real world I would use the correct TO_DATE syntax to avoid truncation and missing the index)</p>
  
  <p>Cheers,</p>