The major differences between the cluster and non cluster indexes are as follows.
1 A cluster index is a form of tables which consist of column and rows.
2 Cluster index exists on the physical level
3 It sorts the data at physical level
4 It works for the complete table
5 There is a whole table in form of sorted data
6 A table can contain only one cluster index
Non Cluster Index
1 A non cluster index is in the form of a report about the tables.
2 They are not created on the physical level but at the logical level
3 It does not sort the data at physical level
4 A table has 255 non clustered indexes
5 A table has many non clustered indexes.
6 It work on the order of data
The table can have indexes in many forms. A table cannot have a single index in it, neither cluster and nor non cluster index. It is also possible that a table has only single cluster index and does not have any non clustered index or vice versa.