Re: Update statistics...anytime?

Jay Aymond wrote: > > 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 > *************************************************************** I am not sure which version of Informix you are using. But in DSA 7.23, there is a shared lock put on the table and an exclusive lock on the system catalogue only when DSA has to update the information there. Dilip Kikla