Update Statistics

Posted in 2005

Colin Dawson — Wed, 14 Dec 2005 11:39:36 +0000 — source: Usenet: comp.databases.informix

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