Re: Update statistics...anytime?

Posted in 1998

Neil Truby — Mon, 02 Feb 1998 20:59:10 +0000 — source: Informix-list mailing list archive (1991-1998)

Ian Clark wrote: > > Hi All, > > Can you apply UPDATE STATISTICS to a table at any time? > > I'm just getting to grips with some in-house developed software at my > new compan and as well as improving the backup scripts I was going to > perform a bcheck just prior to the backup and then perform an UPDATE > STATISTICS after the backup. > > Does this sound ok to anyone? I don't think any UPDATE STATISTICS has > been performed on any table here before. > > Cheers, Ian. > Tedious office-speak part 3: "Let's go scuba in the think tank." Sounds OK. You should try to avoid times when your users are on, are it's an intensive process. Do you have any batch processing that inserts or deletes a large number of rows? After this would be a good time to do UPDATE STATISTICS. Neil Truby Chase Manhattan Bank Bournemouth, UK neil.truby@chase.com