Re: UPDATE STATISTICS

Posted in 1997

Ian Goddard — Wed, 30 Apr 1997 00:58:34 -0700 — source: Informix-list mailing list archive (1991-1998)

David Williams wrote: > > In article <19970425213301.RAA05883@ladder01.news.aol.com>, Belakimem > <belakimem@aol.com> writes <snip> > >Does anyone have any ideas regarding the logistics of running of UPDATE > >STATISTICS in a 24 hour environment? > > > Yes. Do not do plain update statistics > > Use update statistics for table <tablename> and update statistics > for procedure <procedure name>. > > Write scripts to do these and break down the task of doing the whole > database into several scripts. Each one can be run during 'quiet' > time on the system. > Alternatively as 4GL or ESQL. Take the names of tables and procs out of the system catalogue tables. That way your program becomes aware of new targets to update and you don't have to maintain scripts. Ian