两个查询index size的sql

因为sp_spaceused 只能得到一个表中所有index size的总和，所以用下面两个sql中的一个查询每一个index具体的大小。

SELECT    i.name                  AS IndexName,    SUM(s.used_page_count) * 8   AS IndexSizeKBFROM sys.dm_db_partition_stats  AS s JOIN sys.indexes                AS iON s.[object_id] = i.[object_id] AND s.index_id = i.index_idWHERE s.[object_id] = object_id('dbo.TableName')GROUP BY i.nameORDER BY i.nameSELECT    i.name              AS IndexName,    SUM(page_count * 8) AS IndexSizeKBFROM sys.dm_db_index_physical_stats(    db_id(), object_id('dbo.TableName'), NULL, NULL, 'DETAILED') AS sJOIN sys.indexes AS iON s.[object_id] = i.[object_id] AND s.index_id = i.index_idGROUP BY i.nameORDER BY i.name