Re: Table updated????

Posted in 1996

David Williams — Wed, 20 Nov 1996 00:50:05 +0000 — source: Informix-list mailing list archive (1991-1998)

In article <01bbd5cf$29e5e760$a74750c6@irwin.interaccess.com>, Irwin Goldstein <irwin@objectsoft.com> writes >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. > >One thing you can do is check the results of: > > select count(*) from table> This will be very slow on a large table. You may as well do update statistics on the table. -- David Williams