outer join versus not exists

Поиск
Список
Период
Сортировка
От chester c young
Тема outer join versus not exists
Дата
Msg-id 20030318165427.52097.qmail@web12703.mail.yahoo.com
обсуждение исходный текст
Ответы Re: outer join versus not exists
Re: outer join versus not exists
Список pgsql-sql
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 по дате отправления: