Re: Update Statistics

Ford, Andrew G wrote: > Probably. dostats will run update statistics high and medium with the > distributions only syntax so the low is needed to populate the > sysindexes, syscolumns and systable information for the table and > indexes (nrows, colmin, colmax, leaves, nunique, etc. distributions > only does not gather this information) as well as submit any logically > deleted index pages to the btree cleaner for physical deletion (I don't > know if it does this for later versions where the btree cleaner was > replaced by the btree scanner.) > > What version of IDS are you running? There are some update statistics > performance improvements that you can take advantage of that were added > in 7.31xD3 and 9.30xC3 if run times are a concern. The next release of dostats implements these optimizations and automatically detects server versions to turn them on and off (also an override option). I'll be uploading the next release shortly - finally go approval to continue maintaining and publishing my utils. Art S. Kagel > Andrew Ford > > > -----Original Message----- > From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] > On Behalf Of Colin Dawson > Sent: Wednesday, December 14, 2005 6:40 AM > To: informix-list@iiug.org > Subject: Update Statistics > > > This is some output from dostats > > TABLE(MEDIUM)...SUCCESSFUL (34.174 Secs) > COL1(HIGH)...SUCCESSFUL (963.907 Secs) > COL2(HIGH)...SUCCESSFUL (1061.096 Secs) > COL3(HIGH)...SUCCESSFUL (1250.274 Secs) > COL2, COL3(LOW)...SUCCESSFUL (2331.204 Secs) > COL4(HIGH)...SUCCESSFUL (898.998 Secs) > > The table has has 110M rows in it, is a LOW really necessary considering > a > HIGH has already been run? > > > > > Regards > > Colin > > There are 10 types of people in the world, those that understand binary > and > those that don't > sending to informix-list > sending to informix-list