[informix] How do I know when was the last time "update statistics" command run on a given table -- Posted by inturi on Friday, October 30 2009

Here is the query:

$dbaccess test -

> select constructed from sysdistrib a, systables b where a.tabid=b.tabid and b.tabname="tab";


constructed

10/29/2009


Note: "test" is the database name where table "tab" exist.