optimizer behaviour in 9.4 as compared to 7.31

Hi All, We are in the process of upgrading our database sevrers from 7.31 to 9.40. But we are in kind of a unique situation here where we cannot do full testing of the optimizer behaviour in 9.4 as compared to 7.31 as our dev and model environments are nowhere close to production in terms of size of database. So we just want to get an opinion in general how much difference it would be in terms of optimizer behaviour as compared to 7.31 in 9.40 and go ahead with the risk of not testing it in production similar environment. Are the queries gonna take altogether different path as compared to 7.31 in 9.4 or it would be pretty much same. Has anybody who upgraded from 7.31 to 9.4 exeperience dramatic increase/decrease in performance in terms of optimizer behaviour? Any help on this will be highly appreciated. Thanks n regards, Vineet __________________________________ Do you Yahoo!? Vote for the stars of Yahoo!'s next ad campaign! http://advision.webevents.yahoo.com/yahoo/votelifeengine/

Dear Vineet, The chance that you will see a dramatic increase is probably low, as you probably have optimized your application, i.e. you queries already for 7.31. Now what about a dramatic decrease? I think the chances are very low , that some queries get optimized in a complete different way and now result in a bad performance. We experienced only very few minor problems due to the optimizer when SAP started to roll out 9.4. However, the chance is NOT NULL, so in case it hits a central query , which gets executeted thousands of times a day.... Do you have the possibility of testing at least some central parts of your application? Do you have the possibility to change queries, i.e. the application ? With kind regards Tilman Model-Bosch -- Tilman Model-Bosch IBM Data Managment Solutions, Informix Advanced Support c\\\\o SAP AG TECHDEV 05 Neurrotstr.16 69190 Walldorf forum.subscriber@iiug.org wrote on 19/07/2004 21:11:06: > Hi All, > > We are in the process of upgrading our database > sevrers from 7.31 to 9.40. But we are in kind of a > unique situation here where we cannot do full testing > of the optimizer behaviour in 9.4 as compared to 7.31 > as our dev and model environments are nowhere close to > production in terms of size of database. > > So we just want to get an opinion in general how much > difference it would be in terms of optimizer behaviour > as compared to 7.31 in 9.40 and go ahead with the risk > of not testing it in production similar environment. > > Are the queries gonna take altogether different path > as compared to 7.31 in 9.4 or it would be pretty much > same. > > Has anybody who upgraded from 7.31 to 9.4 exeperience > dramatic increase/decrease in performance in terms of > optimizer behaviour? > > Any help on this will be highly appreciated. > > Thanks n regards, > > Vineet > > > > __________________________________ > Do you Yahoo!? > Vote for the stars of Yahoo!'s next ad campaign! > http://advision.webevents.yahoo.com/yahoo/votelifeengine/ > >