Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Chuck Ludwigsen — — source: Informix-list mailing list archive (1991-1998)
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
**
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.