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

    All notes