Prediction of index space

Question

Post reply

Prediction of index space

Sinshith S Anand

SSChasing Mays

Points: 605
More actions
August 4, 2009 at 7:31 am

#212922

How we can Predictively calculate the Index size?....Means if 100 rows takes 8k what about 1 million rows?.....How we can predict the index usage...Please help me on this issue

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

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

ChiragNS One Orange Chip Points: 26137 More actions · Answer 1

check out the BOL topic - estimating table size.

"Keep Trying"

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 2

There is relatively little overhead, and as the number of rows grows, the overhead becomes less of an issue. You basically calculate the index size of one row, using data tables, and then multiply by the number of rows.

http://msdn.microsoft.com/en-us/library/ms178085.aspx