SQL------查看索引大小
标签：object 名称 name rom object_id obj nbsp page partition
SQL------查看索引大小
* 8 AS [索引大小KB]
FROM sys.dm_db_partition_stats AS s
JOIN sys.indexes AS i
ON s.[object_id] = i.[object_id] AND s.index_id = i.index_id
WHERE s.[object_id] = object_id(‘FenZhongJiaGe‘)
GROUP BY i.name
ORDER BY i.name