SQL------查看索引大小
标签：object 名称 name rom object_id obj nbsp page partition
声明：本文来自网络，不代表【好得很程序员自学网】立场，转载请注明出处：http://haodehen.cn/did118355
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
阅读：22次