Re: PDQ

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. Speaking of old parameters, you can also set PSORT_NPROCS to help optimise parallel sorts during UPDATE STATISTICS. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+ sending to informix-list