In pg, is there any performance gain in using outer join with null as
versus using not exists, eg:
select t1.* from t1 right join t2 using( id ) where t2.id is null;
versus
select * from t1 where not exists (select 1 from t2 where t1.id=t2.id);
__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com