MS SQL Server Indexes Question:
Download Job Interview Questions and Answers PDF
Tell me the difference between clustered and non-clustered index?
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 Question | Next Question |
Do you know Clustered and Non-Clustered Index? | What is Unique Index? |