Re: script or spl for update statistics

Posted in 1997

Art S. Kagel — Wed, 03 Sep 1997 11:22:03 -0400 — source: Informix-list mailing list archive (1991-1998)

Zeljan Silje wrote: > > Hi, > > in Informix Guide To SQL Syntax there is recommendation for updating > statistics: > 1) run update statistics with distributions only > 2) run update statistics high for columns with indexes > 3) run update statistics low for multicolumn indexes > > I would like to do recommended update statistics regularly (via cron). > Does anybody has SPL or script (or anything convenient) that is able to > do such a update. If you have ESQL/C I have a program (dostats.ec) that works correctly for all versions of Informix (5,6,7). It can be executed from a cron job or it can write its commands to a script file which you can execute from the cron. Email me if you want the source. Same for anyone else. Art S. Kagel