Is there a way to estimate size of an index?

• n.heyen

  SSCrazy

  Points: 2849

  More actions

  February 16, 2010 at 8:21 am

  #230053

  I recently tried to create an index but it filled the disk and failed. Is there a way to at least estimate the size of an index before it is created? The table in question is pretty deep, 815,103,933 rows at last count. I knew indexes consume a lot of disk, but any way to estimate this?

  Thanks!

  Norman

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  February 16, 2010 at 8:29 am

  #1119313

  it really depends on the data type, microsoft outlines the steps for sizing clustered and non-clustered indexes here;

  http://msdn.microsoft.com/en-us/library/ms187445.aspx"> http://msdn.microsoft.com/en-us/library/ms187445.aspx

• n.heyen

  SSCrazy

  Points: 2849

  More actions

  February 16, 2010 at 10:54 am

  #1119400

  Thanks for the link Steve,

  This is a lot more complex than I had hoped for but it looks like it should be what I was looking for.

  Remember when a terabyte was an unimaginable amount of disk space? 😀

  Norman