Re: UPDATE STATISTICS

Posted in 1997

Vince Pachiano — 14 Jan 1997 15:48:26 GMT — source: Informix-list mailing list archive (1991-1998)

Patrick Stacey <patrick@mediacity.com.sg> wrote in article <32D0A326.353E@mediacity.com.sg>... > 1. Can someone tell me if the UPDATE STATISTICS command generates an > output file for the DBA to read? > > 2. How often should you run this procedure? According to the "good book", "Update the statistics when you perform extensive modifications to a table..." Of course, the definition of extensive is left as an exercise for the reader ;-)