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  (David Rowley <dgrowleyml@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: nikhil raj
Дата:
Сообщение: Re: Take the data from table and rotate the member on every 7th day or starting day of the week and continue for whole week continue till the date range
Следующее
От: David Rowley
Дата:
Сообщение: Re: Looking for an efficient way to replace efficient NOT IN when landling very large data