Re: Update staistics Running Way Slow

Sanjeev sagar wrote: > > This is a multi-part message in MIME format. > --------------FBF95EAB01AE2EFCAE40C116 > Content-Type: text/plain; charset=us-ascii > Content-Transfer-Encoding: 7bit > > Hello All, > > I am running Update Stats on ne fragmented table in 40 > dbspaces and looks like it's running way slow. Please > look at my follwing script, even after setting > PDQPRIORITY, I am not able to see anything in onstat -g > mgm. Because of this I am guessing that I am getting > default allocation which is 128K. I will highly > appreciate any attention and some tips to improvethe > timing of this. I am getting 1hr 15min. No, UPDATE STATISTICS doesn't use PDQ at all AFAIK. This may have changed in 9.20? The normal solution, providing you have the resources, is to run multiple UPDATE commands. You could for instance allocate one command per disk. However, in your case, you are only updating one table, so even this is not possible. You could try reducing the CONFIDENCE so that the sample size is smaller. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+