JOIN for lock contention optimization
JOIN for index optimization
JOIN for query logging
JOIN for query monitoring
JOIN for query distribution