Update Statistics Plan for IDS 7.31
Posted in 1999
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