Answer
The clustered key is included in all non-clustered indexes. Wide keys increase:
- Storage footprint
- Read/write cost
- Fragmentation
- Memory usage
Narrow, sequential keys are ideal.
Quick Answer
Wide clustered keys (GUIDs, composite multi-column keys) are included in every non-clustered index as the row locator. A 16-byte GUID key in a table with 10 non-clustered indexes multiplies key storage significantly. Wide keys also increase page splits and fragmentation over time. An integer identity key keeps everything compact.
S
SugharaIQ Editorial Team
Verified Answer
This answer has been peer-reviewed by industry experts holding senior engineering roles to ensure technical accuracy and relevance for modern interview standards.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ