Check updated date for index statistics

Use the following sql script to check when the statistics for a particular index was updated

SELECT name AS index_name,
STATS_DATE(OBJECT_ID, index_id) AS StatsUpdated
FROM sys.indexes
WHERE OBJECT_ID = OBJECT_ID('MyTable')
GO
Subscribe

0 comments