Re: UPDATE STATISTICS, good?

Posted in 1996

David Williams — Sun, 8 Sep 1996 15:14:12 +0100 — source: Informix-list mailing list archive (1991-1998)

In article <50orj0$9g4@netnews.csie.nctu.edu.tw>, sea <sea@csie.nctu.edu.tw> writes > >I have several stored procedures that use "update statistics for procedure..." >to update some other procedures that this procedure need to reference. >That works fine in INFORMIX 7.1.1, but crash database in INFORMIX 7.1.3. >So, is UPDATE STATISTICS really important, or I can ignore them? >BTW, is this the INFORMIX bug? > > >Jack > You only need to update statistics when the amount of data in a table changes but a large amount. Try running it just once a day. -- David Williams