Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Hamilton, Jerry — — source: Informix-list mailing list archive (1991-1998)
What release of Informix? I've seen many examples of update statistics
killing some queries on versions 7.31 up to 7.31uc2xa. I've been running
7.3xuc2xa with a statistics plan of low/drop and medium on non-indexed
columns, things are running great. Informix tells me to upgrade IDS to
7.3uc6 to fix optimizer problems.
Jerry
"Keep Amateur Wrestling Alive!"
-----Original Message-----
From: Tony Woods [mailto:twoods786@hotmail.com]
Sent: Thursday, June 08, 2000 5:29 PM
To: informix-list@iiug.org
Subject: Update Statistics high vs medium/low
Hello gurus,
Is it by any chance possible that executing update statistics high will slow
down the queries and executing update statistics medium/low will improve the
performance.
Any kind of help is appreciated.
Thanks in advance.
Tony Woods.
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.