performance of IN vs ORs

Does anyone have anything to say with regard to the performance of using IN as opposed to a group of ORs under Informix SE 4.12? ie. WHERE COL1 IN ( var1, var2, var3 ) vs WHERE COL1 = var1 OR COL1 = var2 OR COL3 = var3 and also with regard to WHERE COL1 NOT IN ( var1, var2, var3 ) vs WHERE COL1 <> var1 AND COL1 <> var2 AND COL1 <> var3 I know the implications with regard to DB2 should I presume a similar situation for Informix? Cheers, Ian. %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% % Ian Timms (DBA/Administrator) % Disclaimer: All opinions expressed % % itimms@vprp333q.prop.telecom.com.au % herein are mine and mine alone! % % Ph. 61+3+634-9144 % ==__( pretty piccy goes here )__== % %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%