JOIN for sharding
JOIN for database partitioning
JOIN for concurrency control
JOIN for transaction isolation
JOIN for deadlock prevention