What is clustered index in SQL?
Answers (1)
Add AnswerThe data for the rows are kept in a clustered index, which is a table. It establishes the table data’s order based on key values that can only sort in one direction. There can only be one clustered index per table. It’s the sole index that’s created by default when the main key is generated. Clustered indexes are preferred when many data updates are required in the table.