RE: Update Statistics

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. 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