1. A table can contain only one clustered index
2. On creation of primary key clustered index will be created automatically
3. Clustered index store the data in sequential order Dec /Asc
4. A clustered index can be applied to more than one columns that are called composite clustered index
Example Composite clustered index:
Create clustered index emp_name_email on Employee(Name desc,Email asc)
Non clustered index
Non clustered index store in the different table with index column and row address
ID Name Email
1 A firstname.lastname@example.org
2 B email@example.com
3 C firstname.lastname@example.org
Non clustered index table
B Row Address
A clustered index is faster then nonclustered index why?
because of nonclustered index store data in the separate table so it has to look to the main table for looking for other columns details so it will require on more lookup to the master table.