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/ sending to informix-list

"Vineet Mehrotra" <vin_us@yahoo.com> wrote in message news:cdh81o$uri$1@news.xmission.com... > > 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. Hi there. I've got two pieces of string here. Which one is longer? One of them is green by the way.