:::: MENU ::::

When were the statistics updated?

Run the below script after adding your table name in “ON o.name = ‘YourTableName’ ”
Shows you time and date when index statistics were last updated.

SELECT 'Index Name' = i.name,
'Statistics Date' = STATS_DATE(i.object_id, i.index_id)
FROM sys.objects AS o WITH (NOLOCK)
JOIN sys.indexes AS i WITH (NOLOCK)
ON o.name = 'YourTableName'
AND o.object_id = i.object_id
ORDER BY STATS_DATE(i.object_id, i.index_id);

So, what do you think ?