RE: Not sure whats happening to update statistics

Bug 173898 UPDATE STATISTICS FOR SPECIFIC PROCEDURE COMPILES EVERYPROCEDURE IN THE DATABASE NOT THE SPECIFIC PROCEDURE THE USER HAS REQUESTED > -----Original Message----- > From: owner-informix-list@iiug.org [SMTP:owner-informix-list@iiug.org] > On Behalf Of Colin Dawson > Sent: Wednesday, November 02, 2005 11:55 PM > To: informix-list@iiug.org > Subject: Not sure whats happening to update statistics > > I upgraded a server from 7.31.FD7 to 9.40.FC5, started the > application, > which connected ok, basic tasks worked except for anything involving a > > stored procedure. I thought lets run update statistics for procedure > and see > if that clears the problem (whatever it is) but dostats is taking > 66-72 > seconds for each SP. Does anyone know what is going on? > > > > > > Regards > > Colin > > There are 10 types of people in the world, those that understand > binary and > those that don't > sending to informix-list sending to informix-list