Difference between Clustered and Non-clustered index in SQL?

0

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.

Sql
asked Apr 14, 2023 at 22:57
Sign in to add a comment

0 Answers

0
πŸ“ No answers yet!

Be the first to answer this interview question.

Your Answer

Sign in to post your answer and help the community.