Factors that can contribute to large index sizes include:
- Having many non-clustered indexes
- Indexes with low fill factors
- Indexes on columns with low cardinality (many duplicate values)
- Composite indexes with many columns
Factors that can contribute to large index sizes include: