Re: Update Statistics Plan for IDS 7.31

go to http://www.iiug.org/software/index_DBA.html and get utils2_ak by Art Kagel. This, among others, will automate the task of deciding what tables/columns need update statistics statements generated. Adam Bradley wrote: > Hi all, > > I am trying to formulate an "Update Statistics Plan" for IDS - their is a > plan that is suggested in the "Informix Unleashed" book that seems very > simple and I would like to know if this sounds logical. > > (from Informix Unleashed) > > ... > The following plan strikes a good balance between execution speed and > completeness: > > 1. Run the "UPDATE STATISTICS MEDIUM" command for the whole database.It > will generate index,table, and distribution data for every table and will > re-optimize all stored procedures. > > 2. Run the "UPDATE STATISTICS HIGH" command with "DISTRIBUTIONS ONLY" for > all columns that head an index.This accuracy will give the optimizer the > best data about an index's selectivity. > > 3. Run the "UPDATE STATISTICS LOW" command for all remaining columns that > are part of composite indexes. > > If your database is moderately dynamic, consider activating such an UPDATE > STATISTICS script periodically,even nightly,via cron, the UNIX automated > job scheduler. > > (End of transcript) > > Any problems with this plan? > > Thanks in Advance - Adam