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.
Art S. Kagel — — source: Informix-list mailing list archive (1991-1998)
Irwin Goldstein wrote:
>
> James McCallum <james.mccallum@bradford.gov.uk> wrote in article
> <6slvjg$evj$1@newsreader1.core.theplanet.net>...
[SNIP]
> A simple global "update statistics" will probably not yield the best
> possible performance. Check out http://www.objectsoft.com for a a shell
> script which does one of the Informix recommended sequences of update
> statistics commands. I believe there is also an ESQL/C version of
> something similar in the IIUG archives.
The program is dostats.ec and is found in the submission named:
utils2_ak submitted by me. There is a new version waiting in the wings
that adds support for UPDATE STATISTICS FOR PROCEDURE... I will upload
the update in a week or two after testing.
By default dostats performs the recommended set of UPDATE STATs
commands per the IDS 7.21 release notes with many options to adjust
this behavior. The defaults are optimal for most tables/databases.
Art S. Kagel
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.