Dynamic Update Statistics

We have many tables in various databases in our 7.30.UC2 version of Informix running on Solaris 2.6. In order to run 'Update Statistics ...' for the various tables according to Informix's recommendations we must remember to add the appropriate statements into the update statistics cron job run overnight. Are there any tools to generate the Update statements dynamically based on the system tables and then run them? All comments welcome. Thank you Sent via Deja.com http://www.deja.com/ Before you buy.

On Thu, 20 Jul 2000 01:07:57 GMT, pot1@my-deja.com wrote: >We have many tables in various databases in our 7.30.UC2 version of >Informix running on Solaris 2.6. > >In order to run 'Update Statistics ...' for the various tables according >to Informix's recommendations we must remember to add the appropriate >statements into the update statistics cron job run overnight. > >Are there any tools to generate the Update statements dynamically based >on the system tables and then run them? goto http://www.iiug.org/software/index_DBA.html and pick one. I'm kind of partial to upd_stats, others like utils_ak or mkupdstats. Use whatever floats your boat :o) HTH, Douglas Wilson