- Round robin
Round robin: Data is spread evenly among all the 60 underlying distributions without any regard to data values. There is no specific key used to distribute data.
Hashing: Most common and effective data distribution method. Data is distributed according to the most common distributed according to the value of a selected column.
Replication: Data is copied to every database rather than being split up. Replication is good small lookup tables or dimension tables that are frequently joined with other big tables.