Re: Bad Performance after Upgrades

Posted in 2000

David Williams — Tue, 18 Jul 2000 23:26:49 +0100 — source: Informix-list mailing list archive (1991-1998)

In article <3974C58B.DC6B254B@ucar.edu>, James Skaife <skaife@ucar.edu> writes >Hi, >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! > >James Update statistics? SET EXPLAIN ON shows what? -- David Williams