Re: Dynamic Update Statistics

From: pot1@my-deja.com > >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? Yes, there are several. I will of course recommend mine, because it doesn't require ESQL/C like Art Kagel's excellent dostats. Someone else, I forget who (sorry), has also written one in Perl. If you have no urge to use or learn either, mine just uses dbaccess and the Korn shell. :-) ftp://ftp.iiug.org/pub/informix/pub/mkupdstats.gz -- mine ftp://ftp.iiug.org/pub/informix/pub/utils2_ak.gz -- Art's, I think ftp://ftp.iiug.org/pub/informix/pub/upd_stats.gz -- The Perl one. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

That's not fair Clowny, I don't get to say "Me too!" now! Art S. Kagel Obnoxio The Clown wrote: > > From: pot1@my-deja.com > > > >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? > > Yes, there are several. I will of course recommend mine, because it doesn't > require ESQL/C like Art Kagel's excellent dostats. Someone else, I forget > who (sorry), has also written one in Perl. If you have no urge to use or > learn either, mine just uses dbaccess and the Korn shell. :-) > > ftp://ftp.iiug.org/pub/informix/pub/mkupdstats.gz -- mine > > ftp://ftp.iiug.org/pub/informix/pub/utils2_ak.gz -- Art's, I think > > ftp://ftp.iiug.org/pub/informix/pub/upd_stats.gz -- The Perl one. > > ________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com