Purpose
This page provides the query to check whether statistics has been updated on SQL Server database.
Applicable in CAST Version
Release | Yes/No |
|---|---|
| 7.2.x | ? |
| 7.0.x |  |
Details
To check if the statistics have been updated, run the following query.
Use database_name SELECT o.name, idx.name AS index_name, STATS_DATE(idx.OBJECT_ID, idx.index_id) AS statistics_update_date FROM sys.indexes idx join sys.objects o on idx.object_id = o.object_id and idx.type=2 order by o.name, idx.name
Make sure the that the 'statistics_update_date' of the table indexes is between the last time it has been requested to process the update and the time you are doing the check
Notes / Comments
Related Pages