Re: Problems with Informix DSA

In article <53e4hn$j7l@artemis.ibernet.es>, jicg <1812j30c@sendanet.es> writes >Hello. > >We are migrated from Informix STANDARD ENGINE to INFORMIX On-Line >DSA 7.12.We have a machine IBM G-30 with two processors, 128 MG RAM, >2 Disks. We get less performance with DSA than with STANDARD-ENGINE. >Is it possible? >Is it Normal? >If theres anybody who want to talk about perfomance degradation. >Thank you. > > Set the OPTCOMPIND parameter to 0 not 2 otherwise indicies tend not to get used. It is a known problem which has been reported to Informix. -- David Williams