Re: Why Update Statistics separately

Posted in 1998

Alexander V. Didytch — Wed, 18 Feb 1998 17:47:01 +0200 — source: Informix-list mailing list archive (1991-1998)

Krupa Shankar wrote: > Why "upadte stastistics" should be run through a cron or separately? > > Why can't the Database engine take care of it in online fashion? > > Thanks in advance > > Dhanesh K.V. 1. It could take too much time. 2. It could take too much locks and that command could even fail. 3. Some procedures could not be running during that 4.Let's say you make update like this set a=a+1 and then makes set a=a-1 no update statistics is needed. Sincerely, Alexander