Sql Server, Query Optimization.
table can have only one clustered index, and it’s an integral part of the table’s structure. When you create a clustered index, it essentially reorders the entire table. Key Columns — The columns included in the clustered index are often referred to as the “key” columns. These columns should be