统计信息

来源：互联网发布：印刷厂排版软件编辑：程序博客网时间：2024/05/22 01:53

统计信息：

http://www.cnblogs.com/woodytu/category/684630.html

理解统计信息：

http://www.cnblogs.com/woodytu/p/4517401.html

如何检测过期的统计信息

SELECT      TableName=OBJECT_NAME(i.OBJECT_ID)    ,ObjectType=o.type_desc    ,StatisticsName=i.[name]    ,statisticsUpdateDate = STATS_DATE(i.OBJECT_ID, i.index_id)    ,RecordModified=si.rowmodctr    ,NumberofRecords=si.rowcntFROM sys.indexes i JOIN sys.objects o ON    i.OBJECT_ID=o.OBJECT_IDJOIN sys.sysindexes si ON    i.OBJECT_ID=si.id    AND i.index_id=si.indid WHERE  o.TYPE <> 'S' AND STATS_DATE(i.OBJECT_ID, i.index_id) IS NOT NULLUNION ALLSELECT      TableName=OBJECT_NAME(o.OBJECT_ID)    ,ObjectType=o.type_desc    ,StatisticsName=s.name    ,statisticsUpdateDate= STATS_DATE(o.OBJECT_ID, s.stats_id)    ,RecordModified=si.rowmodctr    ,NumberofRecords=ir.rowcntFROM sys.stats s INNER JOIN sys.objects o ON s.OBJECT_ID=o.OBJECT_IDJOIN sys.sysindexes si ON s.OBJECT_ID=si.id AND s.stats_id= si.indidINNER JOIN (SELECT id,rowcnt FROM sys.sysindexes WHERE indid IN (0,1)) IRON IR.id=o.OBJECT_ID  WHERE  o.TYPE <> 'S'  AND (s.auto_created=1 OR s.user_created=1)AND STATS_DATE(o.OBJECT_ID, s.stats_id) IS NOT NULL

直到SQL server 2008 R2 (SP2) 开始的版本，才有sys.dm_db_stats_properties 对统计的主要列对象改变有详细的统计信息。

阅读全文

0 0