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

[John R Pierce]

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