Show when statistics were last updated for a tables' indexes
Submitted by Andy on Tue, 11/06/2007 - 10:02.
Ever wonder when the last time your table stats where updated (perhaps done automatically because auto_stats is on?). Here is your answer:
SELECT i.name AS [Index Name], STATS_DATE(i.id, i.indid) AS [Statistics Date]
FROM sysobjects o, sysindexes i
WHERE o.name = 'table_name' AND o.id = i.id
