Postgres Pro
Downloads
Home   >   mailing lists

Re: How to hint 2 coulms IS NOT DISTINCT FROM each other - Mailing list pgsql-general

From John R Pierce
Subject Re: How to hint 2 coulms IS NOT DISTINCT FROM each other
Date
Msg-id 83e0223d-7e7e-95eb-f281-455a00e277e7@hogranch.com
Whole thread Raw
In response to How to hint 2 coulms IS NOT DISTINCT FROM each other  (Kim Rose Carlsen <krc@hiper.dk>)
Responses Re: How to hint 2 coulms IS NOT DISTINCT FROM each other
List pgsql-general
Tree view
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 by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: How to hint 2 coulms IS NOT DISTINCT FROM each other
Next
From: Kim Rose Carlsen
Date:
Subject: Re: How to hint 2 coulms IS NOT DISTINCT FROM each other