Re: Question about subselect/IN performance

Поиск
Список
Период
Сортировка
От bricklen
Тема Re: Question about subselect/IN performance
Дата
Msg-id AANLkTinK05Cvu-4tcotn-U3QBuP5C__ZGbGkx_6QPED6@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Question about subselect/IN performance  ("T.H." <calinet6@gmail.com>)
Список pgsql-performance
On Tue, Nov 30, 2010 at 3:23 PM, T.H. <calinet6@gmail.com> wrote:
> Just looking into it now, thanks for the suggestion. Is there a reason that
> EXISTS is generally faster than IN for this sort of query?
>
> -Tristan

Exists will return immediately upon finding a match -- assuming there is one.

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

Предыдущее
От: "Pierre C"
Дата:
Сообщение: Re: SELECT INTO large FKyed table is slow
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: SELECT INTO large FKyed table is slow