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

[John R Pierce <pierce@xxxxxxxxxxxx>]

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