Re: script or spl for update statistics

Art S. Kagel wrote: > > 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 If you don't have esql I've got a ksh script floating around somewhere that will do the same thing, at least for 6 and 7 engines. You are welcome to a copy -- Paul Watson WF Software Ltd. Tel: +44 1436 674729 Fax: +44 1436 678693 Email: paulw@wfsoftware.co.uk