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

From: Informix DBA Survival Guide, 2nd Ed. by Joe Lumbley Query the sysdistrib table. This only works on UPDATE STATISTICS HIGH and MEDIUM. select distinct tabname, b.constructed, b.mode from systables a, sysdistrib b where a.tabid=b.tabid order by 1 My guess is that if you don't know, you probably ought to run it. I'm sure someone out here that doesn't need to read a manual could tell you how to do a check on a plain UPDATE STATISTICS or UPDATE STATISTICS LOW Later, Wynne "Robert walkup" <rdww@ti.com> wrote in message news:39F6DAFA.B01D2C33@ti.com... > Any one know how to determine when update statistics was last run for > a particular table? > > thanks, > Robert Walkup > rdww@ti.com