Index size

Is it normal for Index size to be three times the size of its corresponding
table in SQL 2005
It does not look normal to me. It may be fragmented
did you run
SELECT * FROM sys.dm_db_index_physical_stats
(DB_ID(N',<your db name>'), OBJECT_ID(N'<your table table>'), NULL, NULL
, 'DETAILED');
and check the avg_fragmentation_in_percent ?
"Zack" wrote:

> Is it normal for Index size to be three times the size of its corresponding
> table in SQL 2005
>
>
|||Zack wrote:
> Is it normal for Index size to be three times the size of its corresponding
> table in SQL 2005
Its possible for this to occur. If there is a fillfactor set to a low
percentage and the table has little number of columns.