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