Round-robin distribution scheme

To specify a round-robin distribution scheme, use the FRAGMENT BY ROUND ROBIN clause of the CREATE TABLE statement. The following statement illustrates a fragmented table with a round-robin distribution scheme:

CREATE TABLE account_2
   ...
   ...
FRAGMENT BY ROUND ROBIN IN dbspace1, dbspace2, dbspace3

When the database server receives a request to insert a number of rows into a table that uses round-robin distribution, it distributes the rows in such a way that the number of rows in each of the fragments remains approximately the same (±100). Round-robin distributions are also called even distributions because information is distributed evenly among the fragments. To that end, a newly added round-robin fragment will be favored exclusively by inserts and loads until it no longer has the fewest number of rows among the table’s fragments.