Re: Update Stats slowing.....

Posted in 2006

malc_p@btinternet.com — 21 Mar 2006 06:46:28 -0800 — source: Usenet: comp.databases.informix

Hmmm yup see what you're saying. Currently I just run "UPDATE STATISTICS LOW FOR TABLE...." without a column list specified (after MEDIUM DISTRIBUTIONS ONLY for the whole table and HIGH DISTRIBUTIONS ONLY for each of the index head columns). So I'll change the LOW to do the non-head columns only and check it out. Thanks. (The one true Malcolm)

↪ replying to malc_p@btinternet.com

Art S. Kagel — Tue, 21 Mar 2006 14:15:00 -0500 — source: Usenet: comp.databases.informix

malc_p@btinternet.com wrote: > Hmmm yup see what you're saying. Currently I just run "UPDATE > STATISTICS LOW FOR TABLE...." without a column list specified (after > MEDIUM DISTRIBUTIONS ONLY for the whole table and HIGH DISTRIBUTIONS > ONLY for each of the index head columns). So I'll change the LOW to do > the non-head columns only and check it out. > Thanks. > (The one true Malcolm) > You could just get my dostats utility which performs optimal update statistics commands according to the protocols recommended in the Performance Guide and in John Miller's article. Dostats is contained in the package utils2_ak in the IIUG Software Repository. Art S. Kagel