Clustered Index:
1.Its created on primary key
2.Store data physically according to the order
3.Only one clustered index can be there in a table
4.No extra space is required to store logical structure
5.Data retrieval is faster than non-cluster index
Non-Clustered Index:
1.It can be created on any key
2.It don’t impact the order
3.There can be any number of non-clustered indexes in a table
4.Extra space is required to store logical structure
5.Data update is faster than clustered index