When to update statistics

Posted in 1994

paulw@dev.jcdc.eta.gov — 18 Jul 1994 16:13:04 -0400 — source: Informix-list mailing list archive (1991-1998)

Does anyone have a effective method of knowing when to update statistics on a database? I know if queries are running really slow, to run it and usually there is a increase in the performance, but does any one know where and what to look at to figure out if update statistics needs to the run? -------------------------------------------------------------------------------- Paul Watje SPAMIS Data Center paulw@spamis.jcdc.eta.gov Largest Informix Shop Voice: (800) 598-5008 in San Marcos, TX FAX: (512) 396-6600