02 January,2011 by Jack Vamvas
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