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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment