CODEWITHSUNDEEP
sql-server-2005indexingstatistics
Manjot
Manjot

Reputation: 11516

Find out If index and table statistics are out of date

I Update indexes with full scan weekly. so when I run:

SELECT name AS index_name,
STATS_DATE(OBJECT_ID, index_id) AS StatsUpdated
FROM sys.indexes

Ref: link text

I expect it to show me that all indexes were updated this weekend. But there are several records which look like:

index_name StatsUpdated
clust      2005-10-14 01:36:26.140
clust      2005-10-14 01:36:26.140

What does it mean?

And, How do I know that the statistics are out of date ( if in case I need to update statistics with full scan more often)

thanks.

Upvotes: 4

Views: 3359

Answers (1)

gbn
gbn

Reputation: 432261

With a name like "clust" they are probably system tables and indexes.

Add this filter to check:

WHERE OBJECTPROPERTYEX(object_id, 'IsSystemTable') = 0

Upvotes: 2

Related Questions