Hi all,
Does informix keep track somewhere of the last time update stats was ran on an objects and how it was ran - low, med, high, dist?

Hi there,

First make sure update statistics has been run
eg. update statistics high for table customer

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

The output will be -

tabname customer
constructed 12/21/2003
mode H

Hope it helps.

Regards,

Lloyd

Hi,

and/or can be generated through:
dbschema -d <database> -hd <tabname>

Regards,
Shriyan