FW: Update statistics performance

To answer: Yes, the actual running of update statistics, will slow down your server. But you need to run this to make your system faster. The best would be to run this at a time of day when the system is not so busy, I would say between 12:00 AM and 06:00 AM as you specify in your e-mail below. Regards Dirk >From: "Guido Jimenez M." <pguidojm@yahoo.com> >To: informix-list@iiug.org >Subject: Update statistics performance >Date: Thu, 21 Apr 2005 14:13:35 -0700 (PDT) > >Hi Friends (again) .! > >I wonder if I perform a "update statistics" statement will decrease the >performance of my server? I have HP-UX rx5670 B.11.23 U ia64 3861480093 >unlimited-user license . This Company works 24 hours a day, and from the >12:00 AM to 06:00 AM the activities are low. >What you advise to me ? > >Thanks a lot. > > > > >__________________________________________________ >Do You Yahoo!? >Tired of spam? Yahoo! Mail has the best spam protection around >http://mail.yahoo.com sending to informix-list sending to informix-list