Re: Update Statistics Speedup Help???

At 04:47 PM 1/13/98 -0500, you wrote: } }1) UPDATE STATS on individual tables NEVER databases. }2) Follow the rules in SERVERS_7.2 (if you do not have that file or your } release was one of those that is just a clone of SERVERS_7.1 let me } know I have extracted the text and can post it.) }3) Set PDQPRIORITY to at least 10 (go for 40 if you can run during light } user load. }4) Set PSORT_NPROCS>=40 }5) Set PSORT_MAXALLOC=10240 }6) Either use AT LEAST 4 TEMPDBspaces equally sized or set PSORT_DBTEMP } to list AT LEAST 3 different file systems on different drives again } keeping in mind that the one with the least available space limits } sort space. } (clip) } }Art S. Kagel } } What does item 4 (Set PSORT_NPROCS>=40) accomplish? My Informix documentation states that the upper limit for the PSORT_NPROCS environment variable is 10.