Index capacity calculation

  • Hello guys,

    Are there any guidelines in giving an estimate with regards the storage for non-clustered indexes on an existing table.

    Kind regards

  • Add up the width of each column in the index, then add the width of the clustering key, and multiply the whole lot by the number of rows in the table (assuming we're not talking about a filtered index). That'll give you an approximate figure, but bear in mind that it can be influenced by fill factors, non-leaf pages (if you have a lot of of rows in your table) and the number of rows that can fit on one data page (if your index is particularly wide).

    John

  • Thanks alot

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply