A clustered index determines the physical order of data in a table, and only one clustered index can exist per table.
- True
- False
Answer: True
Clustered index physically sorts table data rows based on index key values. Since data can be sorted in only one order, a table can have only one clustered index (usually on primary key). Non-clustered indexes store logical order separately with pointers to data rows; multiple non-clustered indexes are allowed.