Search

Tuesday, June 12, 2012

SQL Server: When Statistics Last Updated ?

SELECT obj.name, idx.name AS [Index Name],
STATS_DATE(idx.[object_id], idx.index_id) AS [Statistics Date],
s.auto_created, s.no_recompute, s.user_created, part.row_count
FROM sys.objects AS obj WITH (NOLOCK)
INNER JOIN sys.indexes AS idx WITH (NOLOCK)
ON obj.[object_id] = idx.[object_id]
INNER JOIN sys.stats AS s WITH (NOLOCK)
ON idx.[object_id] = s.[object_id]
AND idx.index_id = s.stats_id
INNER JOIN sys.dm_db_partition_stats AS part WITH (NOLOCK)
ON obj.[object_id] = part.[object_id]
WHERE obj.[type] = ‘U’
ORDER BY STATS_DATE(idx.[object_id], idx.index_id) ASC;

No comments:

Post a Comment