The clustered index defines the order in which data is physically stored in a table. The table data can be sorted in only way, therefore, there can be only one clustered index per table. In SQL Server, the primary key constraint automatically creates a clustered index on that particular column
Liked By
Write Answer
what is cluster index in sql
Join MindStick Community
You have need login or register for voting of answers or question.
Anonymous User
05-Aug-2019The clustered index defines the order in which data is physically stored in a table. The table data can be sorted in only way, therefore, there can be only one clustered index per table. In SQL Server, the primary key constraint automatically creates a clustered index on that particular column