Good day Everyone,

I am seeking assistance in understanding how statistics are stored and updated in Informix. From one of the manuals I read, I saw that the SYSDISTRIB, SYSTABLES, SYSCOLUMNS and SYSINDEXES are the tables that are updated, however the data residing in these tables do not make much sense to me....

What I would really like to find out is where information for when the last update statistics statement was run for given tables. Using Sybase I can obtain this information using the 'Optdiag <tablename>' command... is there an Informix equivalent?


Barry Cochrane

Good day again,

I was able to obtain a solution to my earlier post... (browsing through previous messages in this forum )


For those interested:-


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

Apologies, if I wasted anyone's time...


Regards,

Barry Cochrane