Optimizing Semi-Join Patterns

Improve query performance when existence checks are preferred over full joins.