Re: Update Statistics Speedup Help???

In article <34BD2C48.6747@bloomberg.com>, "Art S. Kagel" <kagel@bloomberg.com> writes > >> 2. What is PSORT_MAXALLOC - I can't find any doc for it. > >It is the size of the in-memory sort blocks in KB. While I do not >believe for an instant that PSORT_MAXALLOC=10240 actually allocate a GB >of sort memory, things do test out to run fastest with this value which >is the maximum value. Don't ask how I know about this one, sometimes I >poke my nose into places where it don't belong, OK! Suffice it to say >that PSORT_MAXALLOC is undocumented. > I was documented in Online 5, but not in the 7 manuals. >> Thanks for the tip about the ontape/onbar bug - I hadn't been bitten by >> it yet.... > >Your welcome. > >Art S. Kagel -- 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