SQL 查询卡在统计状态

查询卡在统计状态的SQL优化方法

sql
SELECT 
    t.name AS TableName,
    i.name AS IndexName,
    STATS_DATE(t.object_id, i.index_id) AS LastStatsUpdate
FROM 
    sys.objects AS t
INNER JOIN 
    sys.indexes AS i ON t.object_id = i.object_id
WHERE 
    t.type_desc = 'USER_TABLE';

sql
-- 重新生成表的统计信息
EXEC sp_updatestats;
-- 重新生成指定表的统计信息
UPDATE STATISTICS YourTableName;

sql
-- 使用FULLSCAN选项更新指定表的统计信息
UPDATE STATISTICS YourTableName WITH FULLSCAN;