Re: 7.21.UD1 Perf. Problem

Posted in 1997

Your Name — 25 Jun 1997 22:11:54 GMT — source: Informix-list mailing list archive (1991-1998)

Kerry, One thing I haven't seen mentioned is whether or not a proper UPDATE STATISTICS has been run against tables and columns in this system. Where one could get away with not running UPDATE STATISTICS regularly on a v5 system, DSA absolutely REQUIRES a proper run of UPDATE STATISTICS after conversion from 5 to 7 - and not just to convert indexes. Bill Williams