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.
Important: You
can use the round-robin distribution scheme only for table fragmentation. You cannot fragment an
index with this distribution scheme.