Difference between Clustered and Non-clustered index ?
| Clustered Index | Non-clustered Index |
|---|---|
| Clustered index will be created by default when you create primary key on a column. So we can create one clustered index per table. |
Non clustered index will be created automatically when you create unique key on a column. A table can have no.of unique keys, so we can create no.of non-clustered indexes per table. |
| The Leaf Level of a clustered index is the actual data page. |
The Leaf Level of a non-clustered index does not consist of the actual data page. |
| Only one clustered index can be created. | Many non clustered index(Numbers depends on the database software) can be created. |
