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.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ