June 1, 2005 at 11:47 am
Ya obviously... just never occured to me to have the clustered index not unique. Have you come across a situation where it might be the best way to go?
June 1, 2005 at 12:55 pm
I really like DATETIME columns as candidates for clustered indexes, since I deal very often with range queries for date intervals. I think this is the best way to go here for me. And since I generally don't care about the time in such columns, it's very likely to have duplicates here. So I can't have such indexes declared as UNIQUE.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
June 1, 2005 at 12:59 pm
I see.. nice to know.
I also like dates as primary key but I don't have many range queries so it's maybe not as usefull.
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply