gpt4 book ai didi

sql-server-2005 - SQL Server 2005 - 如何找出特定索引的磁盘大小

转载 作者:行者123 更新时间:2023-12-03 01:26:42 25 4
gpt4 key购买 nike

如何在 sql server 2005 中找到特定索引的磁盘大小?

最佳答案

USE master

SELECT SUM(used_page_count) * 8 AS [Size in kb]
FROM sys.indexes i
JOIN sys.dm_db_partition_stats p ON p.object_id = i.object_id AND i.index_id = p.index_id
WHERE i.object_id=OBJECT_ID('dbo.spt_values') AND i.name='ix2_spt_values_nu_nc'

关于sql-server-2005 - SQL Server 2005 - 如何找出特定索引的磁盘大小,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/4119971/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com