Re: Table updated????

Joseph Cullipher wrote: > > 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. I would suggest just doing the UPDATE STATISTICS, unless it is taking ALL night, or you are using HIGH. Generally, UPDATE STATISTICS is pretty quick. By the time you had hunted down the info on when it was last run, you could have probably run it again. :-) Cheers, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+