What is the difference between Clustered and Non-Clustered index?

A clustered index is a type of index that determines the physical order of data in a table.

A non-clustered index is stored at one place and table data is stored in another place. For example, Book Index.

A table can have only one clustered index.
A table can have multiple non-clustered index.

Clustered index is faster.
Non-clustered index is slower.

Post a Comment

Previous Post Next Post