Adding a New Named Fragment to a Round-Robin Distribution Scheme

In Informix®, you can add a named fragment to an existing round-robin distribution scheme. The name must be unique within the distribution among fragments of the same dbspace. The following example specifies the same original round-robin fragmentation definition as in the previous section: 
CREATE TABLE book (col1 INT, col2 INT) 
   FRAGMENT BY ROUND ROBIN IN dbsp1, dbsp4;
To add a new named fragment, you can use the ADD clause, as in the following example: 
ALTER FRAGMENT ON TABLE book 
   ADD PARTITION chapter3 IN dbsp1;

The new distribution uses dbsp1, dbsp4, and chapter3 as storage locations for a 3-part round-robin fragmentation scheme. The records in the fragment chapter3 are stored separately in the dbspace dbsp1 from the records in the first fragment, which is identified only by the dbspace name: dbsp1. The newly-added chapter3 fragment will be favored exclusively by inserts and loads until it no longer has the fewest rows among the table’s fragments.