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)
Abhay Mannur wrote:
>
> We were running update statistics high for whole database and we wanted
> to reduce the execution time for that. So we planned to find the most
> volatile tables and update staistics high for those tables. When I ran
> that script, it took more time than before.
> Can anybody give me the reason for this or solution for my problem ?
There are suggestions for updating statistics to best utilize the
optimizer and take minimum time. They are in the release notes for
7.2x in $INFORMIXDIR/release/en_us/0333/SERVERS_7.2 and earlier version
of these recommendations are in SERVERS_7.1. There seem to be at least
three different versions of the SERVERS_7.2 file one with no
recommendation, one with the same recommendation as the 7.1 file and
the updated version. You may have any of the above.
You can download the utility package I uploaded to IIUG software
archive. It contains an ESQL program that implements the latest
recommendations. Someone else did a shell script version which
implements most of the V7.1 recommendations.
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.