pg_hint_plan icon indicating copy to clipboard operation
pg_hint_plan copied to clipboard

Hint to use a Nested Loop Semi Join

Open SteveDirschelTR opened this issue 11 months ago • 0 comments

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).

SteveDirschelTR avatar Mar 12 '24 18:03 SteveDirschelTR