Clustered indexes on datetime columns

[Peter Karhatsu]

Does anyone have a recommendation for creating an index on a datetime column?
We use alot of dateranges in our statements and none of them perform very well.
Thanks

Pete Karhatsu

[Jeff Fuhr]

Pete,

A clustered index will work very well with range type queries. As an 8-byte column, it will not add too much overhead to the non-clustered indexes.

However, if this table constantly inserted to, be sure that clustering by the datetime column does not create a new source of contention. This may occur if the datetime represents a transaction date (or other such date which is always increasing).

Good luck; I look forward to seeing replies from other posters on this topic.

Jeff Fuhr

------------
Peter Karhatsu at 6/13/00 12:25:14 PM


Does anyone have a recommendation for creating an index on a datetime column?
We use alot of dateranges in our statements and none of them perform very well.
Thanks

Pete Karhatsu