Precomputed result set - last refresh date

[Former Member]

Hi!

Is there a way to check when the last refresh of precomputed result set/materialized view took place (assuming that we refresh it manually)?

I didn't find it in docs and system tables.

[kevin_sherlock · Accepted solution]

You might try:

select object_name(id),statmoddate

from systabstats

where id = object_id('your_prs_object')

and indid = 0

[Former Member · Accepted solution]

Thanks Kevin. It looks like this works, although not immediately. The date is updated after several seconds.

[kevin_sherlock · Accepted solution]

The only drawback here is that is _is_ possible to "update statistics" on a prs.  In that case, the query reports that fact rather than a "refresh precomputed result set" command.  So, caveat emptor...