Posted by Tony Sebion on 08/04/05 19:14

I think I would take a look at the FILL FACTOR of the index (the % of
the index that is created empty), and possibly do a DBCC SHOWCONTIG to
show the current fragmentation and DBCC REINDEX on the table during a
time of little or no activity if I thought that the tables contents
might be fragmented.

You can look up any of the all-caps terms in Books Online if you want
more info about the commands.

Good luck,
Tony Sebion

"sql_server_2000_user" <sethpurcell@comcast.net> wrote in message
news:1123168931.364988.273310@g47g2000cwa.googlegroups.com:

> Yes! It is intentionally a clustered index. But if the db includes the
> row data pages when it reports the size of a clustered index, why is
> the size of the index not just equal to the size of the table (105GB?)
>
> Thanks,
> Seth

[Back to original message]