RE: Why does this transaction on my IDS 11.70FC2 freeze it up?

It sure doesn't. I will Monday, thanks. Date: Sat, 23 Apr 2011 20:17:06 +0100 Subject: Re: Why does this transaction on my IDS 11.70FC2 freeze it up? From: domusonline@gmail.com To: tmroy@hotmail.com CC: informix-list@iiug.org Does it assert fail? You should open a PMR since that's not a normal situation... Regards. On Sat, Apr 23, 2011 at 1:37 PM, Todd Roy <tmroy@hotmail.com> wrote: Given a table with about 28Million rows, I try to do a simple transaction : set explain on; select count(*) from orhanmle whereanml_sire_key = 12345 or anml_dam_key = 5678 QUERY: (OPTIMIZATION TIMESTAMP: 04-23-2011 08:32:30) ------ select count(*) from orhanmle whereanml_sire_key = 12345 or anml_dam_key = 5678 Estimated Cost: 8 Estimated # of Rows Returned: 1 1) informix.orhanmle: MULTI INDEX PATH (SKIP SCAN) (Key-Only) (1) Index Name: informix.orhanmle_dkey_i2 Index Keys (Detached): anml_dam_key (Serial, fragments: ALL) Lower Index Filter: informix.orhanmle.anml_dam_key = 5678 OR (2) Index Name: informix.orhanmle_skey_i3 Index Keys (Detached): anml_sire_key (Serial, fragments: ALL) Lower Index Filter: informix.orhanmle.anml_sire_key = 12345 Basically the engine completely freezes up, requiring a onclean -k to restart it. The table has had its statistics freshly rebuilt with Art Kagel's dostats. I also dropped and recreated all the indexes. In fact. This occurs with ANY "or" in the where clause. On our production server (11.50FC5) this transaction and others like it are instantaneous! Thanks, Todd Signature _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...