Re: ORDER OF UPDATE STATS : A FOLLOW-UP

This is available for those who have support in the TechInfo section of the Informix web site: http://www.informix.com/informix/services/ilink/alerts/033098.htm A search on the Informix web site for "tech alert" will yield this page. There are only 13 TechAlerts issued, and it is well worth your effort (IMHO) to check that page periodically for new developments. Tim writes: >Selva, > >Can you confirm this information as coming from Informix? > >Thanks in advance, > >Tim > >Tim Schaefer >tschaefe@mindspring.com >http://www.inxutil.com >ICQ:6358805 >#include <dilligaf.h> > > >Selva Rajagopal wrote in message <6gedq8$aqi$1@news.xmission.com>... >> >>Hi all: >> >> I hope the following information will be usefull to you all. >> >>************************************************************************** *** >>*** PERFORMANCE DEGRADATION TECH ALERT *** >>************************************************************************** *** >> >>Potential performance degradation after executing update statistics >>medium or high on Informix Dynamic Server. Affected versions are >>7.23.UC9, 7.23.UC10 and 7.24.UC4. This includes all Unix and NT >>platforms. >> >>Symptom: >>- Transaction processing rate may decrease dramatically after >> executing update statistics high or medium. >>- No error message is associated with this problem. >> >>When it happens: >>Processing transactions after performing update statistics high >>or medium. >> >>Solution: >>The problem will be fixed in the upcoming 7.23.UC11 and 7.24.UC5 >>releases. _____________________________________________________________ Clem Akins (aka clem@informix.com) Menlo Park x5937 Technical Customer Course Development Manager Education Services, Informix Software