Datetime and Indexes

microsoft.public.sqlserver.programming

10 Mar 2006 2:49 PM

antimon

Hi,
I have a table which i need to perform ranging and ordering queries on
a datetime column. Sql server doesn't seem to use nonclustered indexes
on datetime columns for range queries. Would it be better if i create a
clustered index on the datetime column and have a non clustered index
on my primary identity key?

10 Mar 2006 3:05 PM

Green

Yeah. Anytime you need to perform range selection and ordering you
should consider creating an clustered index for that column.