Hi Julian,

Noticed that JoinCommuteRule does not swap outer joins by default. Is there
any specific reason to avoid swapping outer joins? And is there a way to
enable swapping outer joins?

Phoenix hash join output columns from left to right, so we prefer left
outer join over right outer join if hash is possible. So unlike
EnumerableJoin, PhoenixJoin assigns the left hand side with a lower cost
than the right hand side when hashjoin is doable.



Thanks,
Maryann

Reply via email to