Well, if you realy have an index on T2.b, then much more efficient way for your query would be:
select T1.column1 , ....
from T1
WHERE NOT EXISTS
(SELECT null FROM T2 WHERE T2.b=T1.a);
|
Results 1 to 5 of 5
Threaded View
|
Click Here to Expand Forum to Full Width |