Re: "UPDATE STATISTICS" command

Posted in 1995

Kerry Sainsbury — Mon, 13 Feb 1995 21:16:36 +1200 — source: Informix-list mailing list archive (1991-1998)

In article <3hg668$8mn@monroe-emh4.army.mil>, "John C. Sinues" <sinues@prc.prc.mrms.navy.mil> wrote: > Is UPDATE STATISTICS a useful command to run? If so, when is a good > time? each time after a table is updated? Weekly? Succinctly: Yes. It is a Good Thing. And: It depends. If you're not a 24x7 operation then you might as well kick it off in the wee small hours every night. Depends how long it takes to run on your system really. I wouldn't run it after each table update though! Regards, Kerry S --------------------------------------,------------------------------------- Kerry Sainsbury, kerry@kcbbs.gen.nz | THE INFORMIX FAQ Quanta Systems, Auckland, New Zealand | kcbbs.gen.nz:/informix/* | mathcs.emory.edu:/pub/informix/faq/* +64 9 377-4473 (work) 266-6011 (home) | http://www.garpac.com/informix.html