Re: Table updated????

Posted in 1996

Michael Strother — 19 Nov 1996 10:38:24 -0500 — source: Informix-list mailing list archive (1991-1998)

> > Joseph Cullipher <joseph@cannonexpress.com> wrote in article > <56q6b9$b08@cssun.mathcs.emory.edu>... > > I am trying to set up an "update statistics" routine to run on a nightly > > basis. Some of my tables get updated every day but others might only > > get updated once a week. I would like to know if there is a way using > > sql to find out which tables have been updated during the day. I am > > using SE 7.10.UC1 and RGL 6.00.UE3. > It escapes me which feilds they are but look at the information contained in the system catalogs and possibly the Sysmaster database. There is a feild in one of those tables (systables I think) that will reflect the last time update statistics was run for that table. If I can find it soon I'll reply again Michael Strother