locked
Index size RRS feed

  • Question

  • Hi ,

    Why is it so always the index size is doubled or more than the actual table data size?

    What could be reason for this ???

    I used sp_spaceused 'tname'.

    Thanks in Advance.

    Wednesday, March 17, 2010 5:15 AM

Answers

  • Can you post your table structures? A lot depends on what you cluster on. If you have a very large clustering key, that can significantly impact your other indexes as sit is used as the row pointer for every other index.  So if you have the large clustereing key, and you have lots of indexes, your index size could easily dwarf the table size.
    Louis

    Thursday, March 18, 2010 4:33 AM

All replies