← All stickers boomer4you

A clustered index sorts and stores the data rows in the table based on the index key values. Therefore only one clustered index can be created on each table because the data rows themselves can only be sorted in one order.

Q1 a) Explain why it is not possible to have more than one clustered index per relation

msdn.microsoft.co... —  Only one clustered index can be created on table <Tablename>. (Visual Database Tools) Add comments

Block