Re: statistics

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