Recommend how to rewrite the join query to leverage broadcast join.

[tijoparacka]

The idea is to identify which ever table is large need to be the left most table. Also need to consider if query can be rewitten to psuh the filter down and then broadcast the result.