Difference between cluster and non cluster index in SQL server with example

Difference  between cluster and nanocluster index: What is cluster Index:- In SQL server, the primary key constraint automatically build a cluster index column. According to the protocol, there will we only one cluster index per table. A cluster index  is used to define the order to sort the table or arrange the data by alphabetical order. A cluster index is used for define the order or to sort the table or arrange the data by alphabetical order just like a dictionary. It is faster than a non-cluster index. What is non cluster-index:- A non-cluster index collects the data at one place and records at another place. The index carries pointer to the position of the data. According to the protocol a single table can include many non-clustered indexes. Key Difference between Clustered and Non-clustered Index A cluster index is a type of index that sorts the data rows in the table on their key values, whereas the Non-clustered index stores the data at one location and indi...