Why only one clustered index for a table?
(Posted by viewer on April 3rd, 2018)
Answer posted on April 6th, 2018
Clustering Index determines how rows are physically ordered in a table. It is a best practice to sort the table based on key values then create a clustered index. The cluster index is created based on the physical order of the records in the table and we can have only one physical order of the records in the table at any given point of time, so we can create only one clustered index per table.
Clustering index helps to improve the performance in some specific operations such as grouping, ordering and comparison other than the equal condition in where clause.