MS SQL Server Indexes Question:
Explain the difference between clustered and non-clustered index?
Answer:
Both stored as B-tree structure. The leaf level of a clustered index is the actual data where as leaf level of a non-clustered index is pointer to data. We can have only one clustered index in a table but we can have many non-clustered index in a table. Physical data in the table is sorted in the order of clustered index while not with the case of non-clustered data.
| Previous Question | Next Question |
| Explain what is it unwise to create wide clustered index keys? | What is the Fillfactor concept in Indexes? |