hey,
i running this example query
select * from t1 where 1=0 and exists (select 1 from t2 where t1.id= t2.id);
i took the execution plan using set autot traceonly and i noticed that he was also checking the exists predicate. checking this predicate is obviously not necessary.
my question is how can i assure that only the necessary conditions will be evaluated in a situation like this (aka short circuit evaluation) ?
thanks, haki.