<李>
<李>
<李>
<李>
<李>
下面两种情况下会被解压缩(不是整页解压缩,只解压缩相关的数据):
<李>
<李>
<李>
<李>
<李>
<李>
<李>
<李>
SELECT o.name AS [Table_Name], x.name AS [Index_Name],
,,,,,,i.partition_number AS (分区),
,,,,,,i.index_id AS [Index_ID], x.type_desc AS [Index_Type],
,,,,,,i.leaf_update_count * 100.0,/,,,,,,,,,,(i.range_scan_count + i.leaf_insert_count
,,,,,,,,,,,+,i.leaf_delete_count + i.leaf_update_count
,,,,,,,,,,,+,i.leaf_page_merge_count + i.singleton_lookup_count
,,,,,,,,,,),AS [Percent_Update]
得到sys.dm_db_index_operational_stats (db_id(),,空,,空,,NULL),我
JOIN sys.objects o 提醒o.object_id =i.object_id
JOIN sys.indexes x 提醒x.object_id =, i.object_id 以及x.index_id =i.index_id
WHERE (i.range_scan_count + i.leaf_insert_count
,,,,,,+,i.leaf_delete_count + leaf_update_count
,,,,,,+,i.leaf_page_merge_count +, i.singleton_lookup_count), !=0
以及objectproperty (i.object_id IsUserTable),=, 1
ORDER BY [Percent_Update], ASC
SELECT o.name AS [Table_Name], x.name AS [Index_Name],
,,,,,,i.partition_number AS (分区),
,,,,,,i.index_id AS [Index_ID], x.type_desc AS [Index_Type],
,,,,,,i.range_scan_count * 100.0,/,,,,,,,,,,(i.range_scan_count + i.leaf_insert_count
,,,,,,,,,,,+,i.leaf_delete_count + i.leaf_update_count
,,,,,,,,,,,+,i.leaf_page_merge_count + i.singleton_lookup_count
,,,,,,,,,,),AS [Percent_Scan]
得到sys.dm_db_index_operational_stats (db_id(),,空,,空,,NULL),我
JOIN sys.objects o 提醒o.object_id =i.object_id
JOIN sys.indexes x 提醒x.object_id =, i.object_id 以及x.index_id =i.index_id
WHERE (i.range_scan_count + i.leaf_insert_count
,,,,,,+,i.leaf_delete_count + leaf_update_count
,,,,,,+,i.leaf_page_merge_count +, i.singleton_lookup_count), !=0
以及objectproperty (i.object_id IsUserTable),=, 1
null
