Re: PDQ

Mark D. Stock wrote: > > Obnoxio The Clown wrote: > >> David E. Grove wrote: >> >>>>makes a big difference to stuff like index creation and update stats. >>> >>>We learned to be careful with PDQ and UPDATE STATISTICS. >> >> There is a new environment variable (DBUPSPACE?) which, when used with >> PDQ will allocate more memory for the update statistics process which >> means that sorting of the index data will take place in parallel, which >> is much faster. However,what you're describing is the documented >> behaviour of SP compilation. So yes, you don't want to do this for SPs, >> but you do want to do it for data. > > No no no, it certainly isn't DBUPSPACE. That is a very old parameter that > LIMITS the amount of memory that UPDATE STATISTICS can use to 4Mb. Unless > they've changed it. Do pay attention -- of course they have changed it. :o) > Speaking of old parameters, you can also set PSORT_NPROCS to help optimise > parallel sorts during UPDATE STATISTICS. -- Ciao, The Obnoxious One "Ogni uomo mi guarda come se fossi una testa di cazzo"