本文深入探讨了使用系统管理视图和Transact-SQL命令来优化数据库表结构，具体介绍了如何利用sys.dm_db_index_physical_stats和ALTER INDEX REBUILD语句来计算表碎片情况，并详细阐述了重建索引的过程及其对数据库性能的影响。
truncate table
SELECT
object_name(a.object_id) [TableName]
,a.index_id
,name [IndexName]
,avg_fragmentation_in_percent
FROM sys.dm_db_index_physical_stats
(
DB_ID()
, NULL
, NULL, NULL, NULL
) AS a
JOIN sys.indexes AS b
ON a.object_id = b.object_id AND a.index_id = b.index_id;
ALTER INDEX ALL ON [dbo].[vpx_alarm_expression]
REBUILD WITH (
SORT_IN_TEMPDB = ON
,STATISTICS_NORECOMPUTE = ON
,ONLINE = ON);
SELECT
object_name(a.object_id) [TableName]
,a.index_id
,name [IndexName]
,avg_fragmentation_in_percent
FROM sys.dm_db_index_physical_stats
(
DB_ID()
, NULL
, NULL, NULL, NULL
) AS a
JOIN sys.indexes AS b
ON a.object_id = b.object_id AND a.index_id = b.index_id;
ALTER INDEX ALL ON [dbo].[vpx_alarm_expression]
REBUILD WITH (
SORT_IN_TEMPDB = ON
,STATISTICS_NORECOMPUTE = ON
,ONLINE = ON);
扫一扫
3170
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
