Re: Bad Performance after Upgrades

Something else: If you are performing many correlated sub-queries, note that 7.3x tries to unwind these into flat joins. This CAN greatly improve performance if you have the appropriate indexes to support the resulting join code (SET EXPLAIN will tell you if sub- query flattening is occurring) but if the indexes are NOT in place the resulting query plan will be a dog. If this is the problem you can either monitor the problem queries and add any missing indexes or you can turn sub-query flattening off. Check the Administrator's Guide there is an ONCONFIG parameter or environment variable to do that at engine startup time. Art S. Kagel James Skaife wrote: > > 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