IN optimization in 7.2 ?????

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема IN optimization in 7.2 ?????
Дата
Msg-id 20020218152404.A13100@depesz.pl
обсуждение исходный текст
Ответы Re: IN optimization in 7.2 ?????
Список pgsql-general
hi
was there optimization for IN (SELECT ... ) usage in 7.2?
we just got query which runs 7 times as fast with in than with exists !
the query is like select field from table where id in (select ... where
 fieldx in (... IN (...)));

depesz

--
hubert depesz lubaczewski                          http://www.depesz.pl/
------------------------------------------------------------------------
... vows are spoken to be broken ...                 [enjoy the silence]
... words are meaningless and forgettable ...             [depeche mode]

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Work Around for Oracle Context Indexes?
Следующее
От: david blood
Дата:
Сообщение: ...