The join across machines

• A

  Shard the colleges by college_id and perform the join across the network

• B

  Replicate the small colleges table to every shard so the join is local everywhere

• C

  Pull all student rows to one machine and join there

• D

  Denormalise the college name into every student row