outer join versus not exists
От
chester c young
Тема
outer join versus not exists
Дата
Msg-id
20030318165427.52097.qmail@web12703.mail.yahoo.com
Список
Дерево обсуждения
outer join versus not exists chester c young <chestercyoung@yahoo.com>
Re: outer join versus not exists Bruno Wolff III <bruno@wolff.to>
Re: outer join versus not exists Tom Lane <tgl@sss.pgh.pa.us>
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
В списке pgsql-sql по дате отправления
