Microsoft have a very long list of equations to work out, including the use of logarithms.
So I put it into a spreadsheet.
The spreadsheet only deals with non-unique non-clustered indexes at the moment, because that's what I was trying to work out. It should be reasonably simple - plug in the numbers in the cells adjacent to the bold text, make sure that you're calculating the correct number of non-leaf levels in cell B53, and make sure to use it in conjunction with the link above.
This spreadsheet is provided as-is, without warranty. It's for estimating the size of an index - actual size of indexes may vary.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment