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.
Showing posts with label ranging. Show all posts
Showing posts with label ranging. Show all posts
Subscribe to:
Posts (Atom)