In my company, instead of join prefer to use multiple queries, one for each table to improve performance. Is it a valid point because large database with millions of records will slow down linearly with joins. So if we do like 3 queries, each with log N time complexity, it would be better yes definitely!!