Re: Bad Performance after Upgrades

Posted in 2000

Obnoxio The Clown — Tue, 18 Jul 2000 22:55:39 BST — source: Informix-list mailing list archive (1991-1998)

From: James Skaife <skaife@ucar.edu> > >We just upgraded from 7.24.UC8 to 7.31.UC6 and from Solaris 2.6 to 2.7. >Since then our queries are taking a lot longer, ie from seconds to >minutes. I used the same values in the 7.31 onconfig file as I had in >the 7.24 onconfig. What am I missing? Any help is GREATLY appreciated! UPDATE STATISTICS? If you did an "in place" upgrade, UPDATE STATISTICS LOWDROP DISTRIBUTIONS first. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com