.png)
STATS_DATE (Transact-SQL)
Returns the date of the most recent update for statistics on a table or indexed view.
For more information about updating statistics, see Using Statistics to Improve Query Performance.
Requires membership in the db_owner fixed database role or permission to view the metadata for the table or indexed view. For more information, see Troubleshooting Metadata Visibility.
A. Return the dates of the most recent statistics for a table
The following example returns the date of the most recent update for each statistics object on the Person.Address table.
USE AdventureWorks;
GO
SELECT name AS stats_name,
STATS_DATE(object_id, stats_id) AS statistics_update_date
FROM sys.stats
WHERE object_id = OBJECT_ID('Person.Address');
GO
If statistics correspond to an index, the stats_id value in the sys.stats catalog view is the same as the index_id value in the sys.indexes catalog view, and the following query returns the same results as the preceding query. If statistics do not correspond to an index, they are in the sys.stats results but not in the sys.indexes results.
USE AdventureWorks;
GO
SELECT name AS index_name,
STATS_DATE(object_id, index_id) AS statistics_update_date
FROM sys.indexes
WHERE object_id = OBJECT_ID('Person.Address');
GO
Updated content |
|---|
Revisions throughout the document to improve accuracy. |
Topic refers to new statistics content in the topic, Using Statistics to Improve Query Performance. |
