Re: ORDER OF UPDATE STATS : A FOLLOW-UP

Posted in 1998

Tim Schaefer — Wed, 8 Apr 1998 08:38:16 -0400 — source: Informix-list mailing list archive (1991-1998)

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. > >***************************************************************************** > >-###################################################################-####### >-Selvakumar Rajagopal >-Database Specialist Endura Software Corporation >-Technical Service Group Seattle, WA >- Phone:(206) 522-0055 >- Fax:(206) 522-0053 >- E-mail: -selvakumar.rajagopal@enduracorp.com >- Web: http://www.enduracorp.com >-###################################################################-#######