SQL------查看索引大小
时间：2021-07-01 10:21:17
帮助过：25人阅读
*
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
SQL------查看索引大小
标签：object 名称 name rom object_id obj nbsp page partition
