Difference Between Clustered and Non-clustered index
only one clustered index per table where as you can have more than one non clustered index per table
cluster index faster than non-cluster index because the clustered index has to refer back to the table, if the selected column is not present in the index
cluster index determines the storage order of row in a table hence does not require additional disk space but a non-clustered index is stored separately from the table,additional storage is required
A clustered index physically sort all rows while Non clustered Index doesn’t
Clustered Index is automatically created on the primary key column