Find out if index and table statistics are out of date

Question

I update indexes with full crawl per week. so when i run:

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

Link: link text

I expect it to show me that all indexes have been updated this weekend. But there are a few entries that look like this:

 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 the statistics more often with a full scan)

thanks.

Answer 1

With a type name of "clust", they are probably system tables and indexes.

Add this filter to check:

 WHERE OBJECTPROPERTYEX(object_id, 'IsSystemTable') = 0