MS SQL Server Indexes Question:
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
| Previous Question | Next Question |
| Do you know Clustered and Non-Clustered Index? | What is Unique Index? |