This is pretty straightforward:
The join tool right now does only inner joins, requiring the use of the union tool to emulate outer joins.
By itself it works fine, however when having workflows involving a large number of joins and unions with lots of data in it performance is severely impacted, leaving to situations where Alteryx Designer slows down massively even with extra CPU/RAM available.
Thank you and regards,
Marco Zara