MS SQL Server Indexes Question:

Download Job Interview Questions and Answers PDF

Tell me the difference between clustered and non-clustered index?

SQL Server Indexes Interview Question
SQL Server Indexes Interview Question

Answer:

A clustered index reorders the way records are stored. A non clustered index is in which the logical order of the index does not match the physical stored order of the rows on disk. A clustered index is must faster because the index entries are actually data records. There can be just one clustered index per table while there can be up to 249 non clustered indexes

Download SQL Server Indexes Interview Questions And Answers PDF

Previous QuestionNext Question
Do you know Clustered and Non-Clustered Index?What is Unique Index?