Skip to content

Instantly share code, notes, and snippets.

@samirbehara-zz

samirbehara-zz/Finding when the statistics was last updated for the indexes

Last active September 11, 2017 17:36
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save samirbehara-zz/097a4d8b4987240fe2348aec3cf81fe3 to your computer and use it in GitHub Desktop.
Save samirbehara-zz/097a4d8b4987240fe2348aec3cf81fe3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Finding when the statistics was last updated for the indexes
SELECT name AS IndexName,
STATS_DATE(object_id, stats_id) AS LastStatisticsUpdate
FROM sys.stats
WHERE object_id = OBJECT_ID('TABLENAME')
and name ='INDEXNAME';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment