title: SQL Server: Indexing date column in a log table
body: <p>Example table:</p>
  
  <pre><code>CREATE TABLE Log (
      logID    int identity
      logDate  datetime
      logText  varchar(42)
  )
  </code></pre>
  
  <p>logID is already indexed because it is a primary key, but if you were to query this table you would likely want to use logDate as a constraint. However, both logID and logDate are going to be in the same order because logDate would always be set to GETDATE().</p>
  
  <p>Does it make sense to put an extra non-clustered index on logDate, taking into account that for the Log table it is important to have fast writes.</p>