pg_hint_plan
pg_hint_plan copied to clipboard
Hint to use a Nested Loop Semi Join
I have a query that is joining into an EXISTS clause using a Hash Semi Join. I think it will perform better if it would use a Nested Loop Semi Join but I don't see that hint available under the hint list, Join Method. If this is not possible to hint could I request an enhancement to allow that hint (and vice versa where maybe the query is doing a Nested Loop Semi Join and I want it to do a Hash Semi Join).