Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Christoffer Hedgate Cluster That Index! Part Two RE: Cluster That Index! Part Two
chrismj
SSChasing Mays
Points: 618
More actions
August 12, 2004 at 1:54 am
#518596
True, but that kind of defeats the purpose of the clustered index, as you are not likely to do searches on the ID, specially not range searches. You should cluster on other incrementing values that are carrying information, like creation date.