Re: UPDATE STATISTICS

Posted in 1997

"Billy Wheeler" — 10 Jan 1997 02:03:22 -0500 — source: Informix-list mailing list archive (1991-1998)

On 6 Jan 97 at 15:00, Patrick Stacey wrote: > 1. Can someone tell me if the UPDATE STATISTICS command generates an > output file for the DBA to read? No, it doesn't. I've never tried this, but you might SET EXPLAIN ON and then check the contents of sqexplain.out. > 2. How often should you run this procedure? Depends on your transaction volume. If you hammer the database a lot, try and do a daily UPDATE STATISTICS; less frequently for lower volumes. The best guideline is probably: do it as often as you can without affecting user throughput. :-) HTH. -- Ciao, Billy I'd be in favour of apathy, but I just couldn't be bothered...