Identificare le statistiche obsolete o non aggiornate

[FrancyDotNet]

Codice: Seleziona tutto

SELECT
    s.name AS StatisticName,
    o.name AS TableName,
    STATS_DATE(s.[object_id], s.stats_id) AS LastUpdated
FROM
    sys.stats AS s
INNER JOIN
    sys.objects AS o ON s.[object_id] = o.[object_id]
WHERE
    o.type = 'U'
    AND s.auto_created = 0
    AND s.user_created = 1
    AND STATS_DATE(s.[object_id], s.stats_id) < DATEADD(MONTH, -1, GETDATE());