How can I find the allocated size of an index?

I ran sp_statistics on a table and the indexes were displayed along with the
SIZE of the table, but the index SIZE's are NULL. I ran statistics on the
table and the indexes SIZE's remained NULL. So what's the trick to obtain the
size of an indexe's allocation?
Thanks
Michael
Snake wrote:
> I ran sp_statistics on a table and the indexes were displayed along
> with the SIZE of the table, but the index SIZE's are NULL. I ran
> statistics on the table and the indexes SIZE's remained NULL. So
> what's the trick to obtain the size of an indexe's allocation?
> Thanks
> Michael
See "Estimating the Size of a Table with a Clustered Index" in BOL for
all required calculations.
David Gugick
Imceda Software
www.imceda.com
|||Try using sp_MSindexspace. It's not documented but it's reasonably simple.
It will give the size on nonclustered indexes.
"Snake" <Snake@.discussions.microsoft.com> wrote in message
news:FA336D35-BB8C-4172-8AA7-919DFC96759A@.microsoft.com...
>I ran sp_statistics on a table and the indexes were displayed along with
>the
> SIZE of the table, but the index SIZE's are NULL. I ran statistics on the
> table and the indexes SIZE's remained NULL. So what's the trick to obtain
> the
> size of an indexe's allocation?
> Thanks
> Michael
|||Thanks Danny!
"DANNY SCROGGINS" wrote:

> Try using sp_MSindexspace. It's not documented but it's reasonably simple.
> It will give the size on nonclustered indexes.
>
> "Snake" <Snake@.discussions.microsoft.com> wrote in message
> news:FA336D35-BB8C-4172-8AA7-919DFC96759A@.microsoft.com...
>
>