RE: How to improve the performance of update statistics - DBUPSPA

Have you read the following article? http://www7b.boulder.ibm.com/dmdd/zones/informix/library/techarticle/miller/ 0203miller.html You may need to upgrade to 9.30FC2 or a later release before these UPDATE STATISTICS enhancements are available to you. Rick -----Original Message----- From: Zunino, Kathy [mailto:KZunino@dcswins.com] Sent: Thursday, June 19, 2003 11:36 AM To: Informix-List (E-mail) Subject: FW: How to improve the performance of update statistics - DBUPSPACE Just FYI: I spent some time testing various settings of DBUPSPACE. On my current version, 9.30.FC1 - it doesn't seem to make any difference what I set or don't set it to. I set is as low as 512k, and as high as 10,240k, or not at all. Regardless of the settings, my update statistics ran at the same pace. -----Original Message----- From: Zunino, Kathy Sent: Tuesday, June 17, 2003 7:34 AM To: Informix-List (E-mail) Subject: RE: How to improve the performance of update statistics According to TFM "If you do not set DBUPSPACE, the default is a megabyte ( = 1,024 kilobytes)." I expect this doesn't apply to current versions where the update statistics has been substantially improved, but I'm working with 9.30.FC1 which is prior to the latest round of improvements.... <snip> ********************************************************************** Privileged/Confidential information may be contained in this message. If you are not an addressee indicated in this message (or responsible for delivery of the message to such person[s]), you may not copy or deliver this message to anyone. If you have received this message in error, you should destroy and delete it from your computer and notify the sender by reply email. Opinions, conclusions and other information in this message that do not relate to the official business of Diversified Collection Services shall be understood as neither given nor endorsed by the company. Accordingly, Diversified Collection Services disclaims all responsibility and accepts no responsibility for the consequences of any person(s) acting, or refraining from acting, on such information prior to the receipt by that person(s) of subsequent written confirmation. ********************************************************************** sending to informix-list sending to informix-list