title: SQL Server 2008: Ordering by datetime is too slow
body: <p>My table (SQL Server 2008) has 1 million+ records, when I try to order records by datetime, it takes 1 second, but when I order by ID (int), it only takes about 0.1 second.</p>
  
  <p>Is there any way to improve the efficiency? (I already added the datetime column to the index)</p>