Difference between Clustered and Non-clustered index ?




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.
 Difference between Clustered and Non-clustered index

Difference between Clustered and Non-clustered index


Related Searches to Difference between Clustered and Non-clustered index ?