Difference between Clustered and Non-clustered index in SQL?

Asked: Apr 14, 2023

Clustered index- 

Clustered index is used for easy retrieval of data from the database and is faster

Clustered index alters the way records are stored in a database as it sorts out rows by the column which is set to be clustered index.

One table can only have one clustered index.

Non Clustered index-

Non-Clustered index is used for easy retrieval of data from the database and is slower.

Non-Clustered index does not alter the way it was stored but it creates a separate object with a table which points back to the original table rows after searching…

One table can have many non-clustered indexes.

Asked by brijesh

Answers (0)

No answers yet. Be the first to answer!