Re: Update Statistics Speedup Help???

Greg Moye wrote: > > Hey gang, anybody have any good suggestions for things I can do to speed > up UPDATE STATISTICS SQL??? > > I have a few constraints though: I'm reorging SAP dbspaces with SAPDBA, > so I don't have access to the code and can't overhaul it to suit > myself. Generally, SAPDBA follows the Informix suggestions (HIGH for > lead columns in an index etc...). Whatever I do needs to be at the > engine configuration level and invisible to SAPDBA. > > It appears that the UPDATE STATS phase of the reorg is the slowest, so > any ideas to speed it up are appreciated. > > Thanks- Greg Have you tried altering the control scripts so they run the update stats commands on the tables that are changing. There's little running it on static or archive tables if you are tight on time. -- Paul Watson WF Software Ltd Tel: +44 1436 674629 Fax: +44 1436 678693 www.wfsoftware.co.uk