Re: How to hint 2 coulms IS NOT DISTINCT FROM each other

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: How to hint 2 coulms IS NOT DISTINCT FROM each other
Дата
Msg-id 83e0223d-7e7e-95eb-f281-455a00e277e7@hogranch.com
обсуждение исходный текст
Ответ на How to hint 2 coulms IS NOT DISTINCT FROM each other  (Kim Rose Carlsen <krc@hiper.dk>)
Ответы Re: How to hint 2 coulms IS NOT DISTINCT FROM each other  (Kim Rose Carlsen <krc@hiper.dk>)
Список pgsql-general
Дерево обсуждения
On 10/28/2016 9:29 AM, Kim Rose Carlsen wrote:
    JOIN a AS table_b
      ON table_a.id = table_b.id
     AND table_a.key = table_b.key

Anyways, to use an index for that join, you'd need a composite index on id *AND* key, not two separate indexes.



-- 
john r pierce, recycling bits in santa cruz

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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: How to hint 2 coulms IS NOT DISTINCT FROM each other
Следующее
От: Kim Rose Carlsen
Дата:
Сообщение: Re: How to hint 2 coulms IS NOT DISTINCT FROM each other