Re: How to improve the performance of update statistics

Zunino, Kathy wrote: > What do any of you set DBUPSPACE to? I have mine set pretty low at 5000 K, but I was thinking about increasing it quite signicantly to see if that would speed up my 'update stats'. No, no, no! Don't set DBUPSPACE at ALL for maximum performance from UPDATE STATISTICS. With it set, you limit the amount of memory used bythe UPDATE STATISTICS command. With it not set, UPDATE STATISTICS can use what it likes. > Any ideas what the max is? The max is, don't set it. ;-) 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