RE: When was update statistics run
Try something like this:
database <whatever>;
select tabname, colname, constructed, mode, max(seqno)
from sysdistrib dist, systables tab, syscolumns col
where tab.tabid = col.tabid
and col.tabid = dist.tabid
and col.colno = dist.colno
and tabname = '<table_whatever>'
group by 1, 2, 3, 4
> -----Original Message-----
> From: Robert walkup [mailto:rdww@ti.com]
> Sent: Wednesday, October 25, 2000 9:07 AM
> To: informix-list@iiug.org
> Subject: When was update statistics run
>
>
> Any one know how to determine when update statistics was last run for
> a particular table?
>
> thanks,
> Robert Walkup
> rdww@ti.com
>