Re: Major performance problems with Informix Online

<snip> }We upgrade from Informix SE to Informix Online about a week ago and }since then have been experiencing significant performance problems; }significant enough to make the system virtually unusuable. Queries }which previously took 2 or 3 seconds are escalating up to 1-2 minutes. <snip> }# OPTCOMPIND }# 0 => Nested loop joins will be preferred (where }# possible) over sortmerge joins and hash joins. }# 1 => If the transaction isolation mode is not }# "repeatable read", optimizer behaves as in (2) }# below. Otherwise it behaves as in (0) above. }# 2 => Use costs regardless of the transaction isolation }# mode. Nested loop joins are not necessarily }# preferred. Optimizer bases its decision purely }# on costs. }OPTCOMPIND 2 # To hint the optimizer Pete, Set this to 0, which will get you back on track. Have a nice day Felix K. Mathews