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.
The statistics are exported in the sql file created during a dbexport and
run as part of the dbimport. Could this be what they are refering to?
Gerry
PS IDS 7.31 Solaris 9.
"Campbell, John (GE Cons Fin)" <John.Campbell2@ge.com>
Sent by: informix-list-bounces@iiug.org
07/07/2006 10:05
To
<informix-list@iiug.org>
cc
Subject
statistics
9.40.FC5 Solaris 9. Someone has suggested to me that I could unload the
statistics data from the database catalog, run the batch data load, then
put the old statistics back. They did this years ago on a Tandy - I don't
know what database. They claim performance was not negatively impacted
but in fact was good. They seem to feel I am wasting a lot of time
running update statistics. I don't see how this could possibly work on
Informix. Has anyone tried this or heard of it?
thanks in advance
John
_______________________________________________
Informix-list mailing list
Informix-list@iiug.org
http://www.iiug.org/mailman/listinfo/informix-list
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.