Looking for an efficient way to replace efficient NOT IN when landling very large data

Поиск
Список
Период
Сортировка
От Shaozhong SHI
Тема Looking for an efficient way to replace efficient NOT IN when landling very large data
Дата
Msg-id CA+i5JwYoxnYGHXn41AgnN9iJP8FCMDMozgzsn5hc0tvhSSMNVg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Looking for an efficient way to replace efficient NOT IN when landling very large data
Список pgsql-sql
Дерево обсуждения
Select a.id, a.name, b.id, b.name from a_large_table a, definitive b where (a.id, b.name) not in 
(select b.id, b.name from definitive b)

is very slow.

Is there a faster way to do so?

Regards,

David

В списке pgsql-sql по дате отправления: