Update Statistics

Question: When was Update Statistics Last Run?

How can I tell when my last UPDATE STATISTICS was run?

Answer: Query the sysdistrib Table.

If you are using either UPDATE STATISTICS HIGH or UPDATE STATISTICS MEDIUM, you can run the following query against the sysmaster database and see when the last UPDATE STATISTICS was run:

select distinct tabname, b.constructed, b.mode
from systables a, sysdistrib b
where a.tabid=b.tabid
order by 1

This does not work with an UPDATE STATISTICS or an UPDATE STATISTICS LOW, as it depends on the distributions tables.