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.
Jorge Torralba — — source: Informix-list mailing list archive (1991-1998)
Leo_Chen@usc.com.tw wrote:
>
> Hi all:
> if anyone knows when to do the 'update statistics' ?
> Or, if there is any information (some ratios, for example) indicates
> that the engine needs 'update statistics'??
>
> leo
If you have a very active tables (many inserts and delete), you should
update statistics regularly when posible.
One good thing to do if you are not familiar with the process is to read
your release notes in the $INFORMIXDIR/release directory. These notes
explain which level of update statistics to apply to a table or columns
in order for the optimizer to work best.
--
Jorge Torralba Intel
Information Technology HF2-71
(503)696-4587 5200 NE Elum Yung Parkway
Hillsboro, Or 97124
=====================================================
Any views or opinions expressed by me do not reflect
those of Intel Corp.
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.