Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 individual index size

Author  Topic 

rb1373
Yak Posting Veteran

93 Posts

Posted - 2005-09-06 : 18:13:59
How do I determine the size of an index?

Thanks,
Ray
SS2K

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2005-09-07 : 06:48:24
size?....as in width per row per table or size as in overall KB/MB/GB per table?
in EM (on sql2k)....the latter can be got using the "taskpad view"

I'm sure there is a script posted here that would calculate it.....search around!
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-09-07 : 06:53:06
This might help:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=53843

That will give you the data and total index size of each table, but you can easily modify it to show the size of individual indexes.
Go to Top of Page
   

- Advertisement -