What is a clustered index and non-clustered index?
A clustered index is an index in which the data in the table is physically ordered based on the values in the index. Clustered indexes can improve query performance for certain types of queries.
A non-clustered index is an index in which the data in the table is not physically ordered based on the values in the index. Non-clustered indexes can improve query performance for certain types of queries.
