Re: Why Update Statistics separately

Posted in 1998

Mark D. Stock — Tue, 17 Feb 1998 12:44:28 +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? Have you seen what 'UPDATE STATISTICS' DOES? If we did that for every database change, we'd be as slow as the competition! ;-) Besides, every site has different requirements for statistics and hence performance. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com FAQ http://www.iiug.org |///// / //| | +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+