Why only one clustered Index in SQL Server? Can you please explain in more detail?
Clustered index sorts whole table in a particular order according to cluster key .You cannot have two order in which table can be sorted .If there were 2 PK they would try to sort them in 2 order which is not possible so only one PK is allowed.
Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers
No comments:
Post a Comment