sojankurian
Programmer
Informix IDS 7.31,
Query like this one is not working on my server
select count(*) from t2
where fld1 not in (select fld1 from t1 )
But I have used this kind of SQL earlier on same version of informix.
I asked the same question to DBA, as per him "This behavior is the same across the engine versions" his suggestion is as given below,
select count(*) from t2
where t2.fld1 not in (select t1.fld1 from t1,t2 where t1.fld1=t2.fld1);
Any idea informix doesn't support "not in" if the second query return large volume of rows. Can it be solved by changing some parameters?
Thank you very much.
Query like this one is not working on my server
select count(*) from t2
where fld1 not in (select fld1 from t1 )
But I have used this kind of SQL earlier on same version of informix.
I asked the same question to DBA, as per him "This behavior is the same across the engine versions" his suggestion is as given below,
select count(*) from t2
where t2.fld1 not in (select t1.fld1 from t1,t2 where t1.fld1=t2.fld1);
Any idea informix doesn't support "not in" if the second query return large volume of rows. Can it be solved by changing some parameters?
Thank you very much.