Wednesday, March 7, 2012

Datetime and Indexes

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?Yeah. Anytime you need to perform range selection and ordering you
should consider creating an clustered index for that column.

No comments:

Post a Comment