RE: statistics

Yes, that was the suggestion - unload and keep the old distributions, run the load (insert/update routine), drop the distributions, and then put the old distributions back. -----Original Message----- From: gsturkenboom@lic.co.nz [mailto:gsturkenboom@lic.co.nz] Sent: Thursday, July 06, 2006 6:28 PM To: Campbell, John (GE Cons Fin) Cc: informix-list@iiug.org; informix-list-bounces@iiug.org Subject: 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