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

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to hint 2 coulms IS NOT DISTINCT FROM each other
Date: 2016-10-28 18:28:33
Message-ID: 83e0223d-7e7e-95eb-f281-455a00e277e7@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kim Rose Carlsen 2016-10-28 18:39:30 Re: How to hint 2 coulms IS NOT DISTINCT FROM each other
Previous Message Merlin Moncure 2016-10-28 18:28:02 Re: How to hint 2 coulms IS NOT DISTINCT FROM each other