02 January,2011 by Jack Vamvas
SQL Index Statistics missing - How can I view a list of indices and the last time the statistics were updated?
The STATS_DATE resturns the date the statistics for the specific index were last updated - the 2 arguments are table_id and index_id.The STAS_DATE could also be used in WHERE clause
The statblob column - is the Statistics binary large object(BLOB). Therefore the DATALENGTH (si.statblob) returns the number of bytes in for that column
Use this DBA script to identify the last time statistics were updated
SELECT LastTimeUpdated = STATS_DATE(si.id, si.indid) ,TableName = object_name(si.id) ,Name = RTRIM(si.name) ,Size = DATALENGTH (si.statblob) FROM sysindexes si WITH (nolock) WHERE OBJECTPROPERTY(si.id, N'IsUserTable') = 1 order by LastTimeUpdated, tablename