RE: FW: Update statistics performance
A consultation on the matter: I can execute the Update Statistics of
databaseA in parallel with dbexport of databaseA. No problem ????
Thank's
===========================================================
>From: "Dirk Moolman" <DirkM@mxgroup.co.za>
>To: <pguidojm@yahoo.com>
>CC: <informix-list@iiug.org>
>Subject: FW: Update statistics performance
>Date: Tue, 10 May 2005 10:12:14 +0200
>
>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
sending to informix-list
no, the dbexport would attempt to take an exclusive lock on the
database. UPDATE STATISTICS would at least take a shared lock so
whichever runs second will fail.