Re: UPDATE STATISTICS

Posted in 1997

David Williams — Sat, 26 Apr 1997 11:04:34 +0100 — source: Informix-list mailing list archive (1991-1998)

In article <19970425213301.RAA05883@ladder01.news.aol.com>, Belakimem <belakimem@aol.com> writes >Why doesn't the engine UPDATE STATISTICS automatically? > It would be too slow when lots of updates are happening. Better to use idle time when users are not using the system. i.e. update overnight. >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. > >Thank you and please also reply via email. -- David Williams