Re: Update statistics...anytime?

Posted in 1998

Jay Aymond — Mon, 02 Feb 1998 17:07:46 GMT — source: Informix-list mailing list archive (1991-1998)

ian@tubeway-army.demon.co.uk (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." "Update Statistics" will place an exclusive table lock on the table that it is being performed on, so it should be done only when there are no potential users of the database. *************************************************************** Jay Aymond United Life & Annuity Insurance Company Email: jay@ulife.com ***************************************************************