Results 1 to 10 of 10
Apr 19, 2013, 06:51 #1
- Join Date
- Jun 2002
- 141 Post(s)
- 0 Thread(s)
Does a Clustered Index involving a Date/Time ever make sense?
I recently found a table where I work and they have a cluster index that contains a date/time column. This column contains date (year, month, day), and time (hour, minute, second, millisecond).
I can't see how that would ever be useful or not hinder the performance of the table instead of helping it. Most lookups to that table involve its primary key (which is not a date/time, it is an identity integer), second most used lookup involves another integer column which is a foreign key reference.
Thoughts? Can any good come from having a date/time in a clustered index?Be sure to congratulate xMog on earning April's Member of the Month
Go ahead and blame me, I still won't lose any sleep over it
My Blog | My Technical Notes