Re: Update statistics...anytime?

Posted in 1998

W. H. SMITH — Mon, 02 Feb 1998 18:26:07 GMT — 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. Update statistics will lock the table in exclusive mode. It shouldreally take place when no one is on the system. We run our scripts overnight. John Carlson Informix DBA WH Smith, Inc.