Re: Last time update stats ran

Art S. Kagel wrote: > > Carl Gruber wrote: > > > > His everyone! > > > > Is there an easy way to tell when the last time an "update stats" ran for > > a particular table? > > No. Create a table and have your update statistics job maintain a > record there, perhaps one row per database or even per table. > > Art S. Kagel Beg to differ Art. Look at the contents of sysdistrib and notice the column named constructed. That is the date the distribution info was generated by update statistics. Therefore, run this query: select distinct tabname, b.constructed, b.mode from systables a, sysdistrib b where a.tabid=b.tabid order by 1 ---- Chuck Ludwigsen <cludwigs@hotmail.com> Sr Engineer <cludwigsen@worldnet.att.net> Summit Data Group President - Memphis Informix UsrGrp <miug@hotmail.com> ** Formerly of Harrah's Entertainment -- Moving on to bigger things ** ** My opinions are my own and might conflict with those of my employer **