Re: Update statistics automatic ?

Posted in 1999

Leonid Belov — Thu, 05 Aug 1999 09:34:56 -0300 — source: Informix-list mailing list archive (1991-1998)

Pascale wrote: > Hi everybody, > > I will have more information about update statistics > > On a online informix database 7.23, does statistics updated automatically ?? No > > or must I have to "isql" update statistics ?? You must issue UPDATE STATISTICS explicitly. Note: if your database is relatively big you'll get "Long transaction" or "No more locks" error so you should UPDATE STATISTICS on each table separately Leonid