IDS Forum

Re: update statistics

Posted By: FRANK
Date: Thursday, 6 September 2012, at 6:00 p.m.

In Response To: Re: update statistics (John Miller iii)

Thanks, John and Art!

The original question came from one of our tests.

We found the two approaches might be Different ( or yielded different
statistics data).

The reason is , for the same set of jobs, approach one( one update
statistics statement for whole database) seems giving a better or more
complete descriptive statistical data, which made jobs run faster(
compared to the second approach) !

Anyway, just for curiosity .

Thanks again
Frank

On Thu, Sep 6, 2012 at 5:21 PM, John Miller iii <miller3@us.ibm.com> wrote:

> To be total accurate there is a difference between the two scenarios.
>
> The difference deals with locking and transaction scope.
>
> If you are not using ANSI logging mode and do not do a begin work
> before the update stats command then I would see no difference.
>
> John F. Miller III
> STSM, Embedability Architect
> miller3@us.ibm.com
> 503-578-5645
> IBM Informix Dynamic Server (IDS)
>
> ids-bounces@iiug.org wrote on 09/06/2012 02:05:32 PM:
>
> > From: "FRANK" <yunyaoqu@gmail.com>
> > To: ids@iiug.org,
> > Date: 09/06/2012 02:08 PM
> > Subject: Re: update statistics [28249]
> > Sent by: ids-bounces@iiug.org
> >
> > We believe they are both syntactically and semantically correct, IDS
> > allowed? Not agree?
> >
> > We ask the difference, not the quality of their results.
> >
> > Thanks,
> > Frank
> >
> > On Thu, Sep 6, 2012 at 4:36 PM, Fernando Nunes
> <domusonline@gmail.com>wrote:
> >
> > > Both of them are completely wrong because they don't follow
> > > recommendations. Check performance guide.
> > > On Sep 6, 2012 9:31 PM, "FRANK" <yunyaoqu@gmail.com> wrote:
> > >
> > > > Hi, Folks,
> > > >
> > > > IDS11.50 FC8
> > > >
> > > > Assume a database has 100 tables: tab1,tab2,....tab100.
> > > >
> > > > What are the Major differences between the following two approaches
> for
> > > > updating statistics?
> > > >
> > > > Approach 1: Just run a "update statistic" for whole database,
> > > >
> > > > update statistics;
> > > >
> > > > Approach 2: Run update statistics for each single table, plus for
> > > > routine/function/procedure,
> > > >
> > > > update statistics for table tab1;
> > > > update statistics for table tab2;
> > > >
> > > > ............................
> > > >
> > > > update statistics for table tab100;
> > > >
> > > > update statistics for procedure;
> > > >
> > > > update statistics for routine;
> > > >
> > > > update statistics for function;
> > > >
> > > > Thanks,
> > > > Frank
> > > >
> > > > --14dae93407a56c139f04c90e5ed6
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
>
>
> *******************************************************************************
>
> > > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > > >
> > > >
> > >
> > > --00248c711bb9d1dace04c90e71b2
> > >
> > >
> > >
> > >
> >
>
>
> *******************************************************************************
>
> > > Forum Note: Use "Reply" to post a response in the discussion forum.
> > >
> > >
> >
> > --14dae9340cebddd3ec04c90ed90f
> >
> >
> >
>
>
> *******************************************************************************
>
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--14dae93407a5b216ca04c90f9fb9

Messages In This Thread

• update statistics
  FRANK -- Thursday, 6 September 2012, at 4:31 p.m.
  • Re: update statistics
    Fernando Nunes -- Thursday, 6 September 2012, at 4:36 p.m.
    • Re: update statistics
      FRANK -- Thursday, 6 September 2012, at 5:05 p.m.
      • Re: update statistics
        Art Kagel -- Thursday, 6 September 2012, at 5:14 p.m.
      • Re: update statistics
        John Miller iii -- Thursday, 6 September 2012, at 5:21 p.m.
        • Re: update statistics
          FRANK -- Thursday, 6 September 2012, at 6:00 p.m.
  • Re: update statistics
    Art Kagel -- Thursday, 6 September 2012, at 4:45 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.