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

    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