Home | Previous Page | Next Page   Managing Databases > Table Fragmentation Strategies > Distribution Schemes for Table Fragmentation >

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. Round-robin distributions are also called even distributions because information is distributed evenly among the fragments. The rule for distributing rows to tables that use round-robin distribution is internal to the database server.

Important:
You can use the round-robin distribution scheme only for table fragmentation. You cannot fragment an index with this distribution scheme.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]