The leaf pages of a clustered index holds the data of the table, so multiple clustered indexes means that the data is more in one place.
And, yes, you can have as many clustered indexes as you like, although only technically only one will be called the clustered index, and the other will considered as non-clustered. More exactly, that would be a non-clustered index which includes all columns in the table, either as key columns or as included columns.
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
No comments:
Post a Comment