How do clustered and non-clustered indexes differ?
This question evaluates understanding of physical storage and query performance tuning.
Why Interviewers Ask This
Indexes are critical for speed. Interviewers want to know if you understand how data is physically ordered. Choosing the wrong index type can cripple performance.
How to Answer This Question
Explain clustered index stores rows in key order (only one per table). Non-clustered is a separate structure pointing to rows (many allowed). Discuss use cases: range scans vs point lookups.
Key Points to Cover
- Clustered = physical order
- One clustered index per table
- Non-clustered = separate structure
- Use cases for each
Sample Answer
A clustered index stores table rows in the physical order of the index key, meaning the data pages are the index. You can have only one, ideal for range scans. A non-clustered index is a separate structure mapping keys t…
Common Mistakes to Avoid
- Thinking you can have multiple clustered indexes
- Confusing covering indexes with non-clustered
- Ignoring physical storage implications
Sound confident on this question in 5 minutes
Answer once and get a 30-second AI critique of your structure, content, and delivery. First attempt is free — no signup needed.