Wednesday, February 17, 2010

ID for Clustered index

Index Optimization Tips: "Avoid creating a clustered index based on an incrementing key."
That's a surprising tip - though could be logical. I wonder if I/O bottleneck is an issue, when there is only 1 filegroup used in the database (ro for the table)...

No comments: