During a large implementation a couple years back we were advised by NS Tech team to avoid using joins because of a massive hit on performance. I have to imagine they’ve been improving since then, but something to keep in mind. Essentially it exponentially increases time/effort