RE: Update Stats not updating for all the Tables

If you run "update statistics high" and the constructed date for statistics is not current, thus suggests that the table(s) concerned were open and update statistics could not be run on them. Under some circumstances, thestatistics for some tables being updated do not get their statistics updated. If this is the case for many weeks then I would change the time of the update stats - unless some process has this table (almost) permanently locked. MW > -----Original Message----- > From: owner-informix-list@iiug.org > [mailto:owner-informix-list@iiug.org]On Behalf Of KalpanaPai > Sent: Monday, 8 September 2003 11:06 a.m. > To: informix-list@iiug.org > Subject: Update Stats not updating for all the Tables > > > Hi All > > We are running Update statistics high for the whole database every > night as a cron job, as our database is small of 1.5 GB. When i run > the following query > next day > > Select distinct tabname,b.constructed,b.mode > from systables a,sysdistrib b > where a.tabid = b.tabid > order by 1> > for the database, i found few tables especially the tables which has > more inserts everyday , one tables has 50000 rows and another had > 10000 records, have been updated 3 months ago , but for rest of the > tables it shows the current date. > > Why only few tables not updating on the production box but the same > cron runs and updates the test box???????? > Any suggestions would be highly appreciated. > > Thanks in Advance > Kalpana Pai sending to informix-list