SQL Index Statistics missing - If there is a requirement to view a list of indices and to assess the last time the statistics were updated ,this script will help.

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

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