Re: when to 'update statistics' ???

Posted in 1997

"Billy Wheeler" — 31 Jan 1997 08:33:29 -0500 — source: Informix-list mailing list archive (1991-1998)

On 30 Jan 97 at 17:48, Leo_Chen@usc.com.tw wrote: > if anyone knows when to do the 'update statistics' ? > Or, if there is any information (some ratios, for example) > indicates > that the engine needs 'update statistics'?? There are no indicators. A good rule of thumb is to do it as often as you can without hanging up your machine... Once a day is about right. HTH. -- Ciao, Billy "...nod's as good as a wink to a blind bat..."