More Queries on Update Stats.

Using Informix 7.20. Suppose I will to only run Update Statistics on 10 tables initially, can someone please confirm a) the syntax of the command b) can the table be accessed by users at the same time c) is ther any danger whatsoever with running this command ie. failing / aborting before completion. Your help is very much appreciated. Jim. jimspiers999@my-deja.com Sent via Deja.com http://www.deja.com/ Before you buy.

jimspiers999@my-deja.com wrote: > > Using Informix 7.20. > Suppose I will to only run Update Statistics on 10 tables initially, > can someone please confirm > > a) the syntax of the command > b) can the table be accessed by users at the same time User processes and the update statistics process should use SET LOCK MODE TO WAIT 1 ( or any higher value ). A lock will be placed on the system tables systables, syscolumns, sysindexes, ( sysfragments ) for a very short time. > c) is ther any danger whatsoever with running this command ie. > failing / aborting before completion. > > Your help is very much appreciated. > > Jim. > jimspiers999@my-deja.com > > Sent via Deja.com http://www.deja.com/ > Before you buy. Regards, Stefan