索引大小 [英] index sizes

问题描述

您好，

我正在使用SQL Server 2016。

我有一个有1000个表的数据库。每个表都有多个索引（聚簇和非聚簇）。

我需要找到每个表的所有这些索引的大小。 

请让我知道如何在单个查询中获取它。

谢谢

---

解决方案

  USE  dbname 

SELECT i。[name] AS IndexName

    ，SUM（s。[used_pa​​ge_count]）* 8 AS IndexSizeKB

FROM sys.dm_db_partition_stats AS s $
INNER JOIN sys.indexes AS i ON s。[object_id] = i 。[object_id]

    AND s。[index_id] = i。[index_id]

GROUP BY i。[name]

ORDER BY i。[name]

GO

https://blog.sqlauthority.com/2016/11/13/find-size-indexes-database-interview-question-week-097/

Hello,

I am using SQL Server 2016.

I have a database which has 1000 tables. Each table has multiple indexes(clustered and non-clustered).

I need to find the sizes of all these indexes of each table. 

Please let me know how to get it in single query.

Thanks

---

解决方案

 USE  dbname 
SELECT i.[name] AS IndexName
    ,SUM(s.[used_page_count]) * 8 AS IndexSizeKB
FROM sys.dm_db_partition_stats AS s
INNER JOIN sys.indexes AS i ON s.[object_id] = i.[object_id]
    AND s.[index_id] = i.[index_id]
GROUP BY i.[name]
ORDER BY i.[name]
GO

https://blog.sqlauthority.com/2016/11/13/find-size-indexes-database-interview-question-week-097/

这篇关于索引大小的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！