Re: Update Statistics Speedup Help???

In article <34BA78EB.3482@eds.com>, Greg Moye <greg.moye@eds.com> writes >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 Run it wiht a higher PDQPRIORITY. Allocate many temp dbspaces spread across disks (1 temp dbspace per disk). Be aware that there have been problems with unevenly sized temp dbspaces and when one fills up Online does not use the next one but gives an error to your session. I would size all your temp dbspaces evenly and not make them too small. Fragmenting tables more may help, allowing more scan threads to be generated hence increases parallelism (Art - bet you have some useful experince here, one for the FAQ please??). -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care