Re: Update Statistics Plan for IDS 7.31

Adam Bradley wrote: <snip> > 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 We have migrated from 5.10 to 7.30UC9 a month ago. I do not understand philosophy of 7.x "update statistics" command at all. We have 10 GB DB with about 700 tables and more then 1000 indexes. Am I supposed to look at every table/index and do separate "update statistics high" for each important index ?? "Update statistics high" for whole DB takes 6.5 hours. We do "update statistics mediam" (which takes cca 1 hour) every night. Is there any way how to find if adding "update statistics high" on specific column (which ?) would improve performance ? michal -- -------------------------------------------------------------- Michal Hajek mailto:hajek@nspuh.cz Sprava NIS http://www.nspuh.cz NsP Uherske Hradiste phone : voice +420 0632 529 204 Purkynova 365 fax +420 0632 551 014 686 68 Uherske Hradiste Czech Republic ICQ UIN: 14290832 --------------------------------------------------------------