Combining Nonfragmented Tables to Create a Fragmented Table

When you transform tables with identical table structures into fragments into a single table, you allow the database server to manage the fragmentation instead of allowing the application to manage the fragmentation. The distribution scheme can be round-robin or expression based.

To make a single, fragmented table from two or more identically-structured, nonfragmented tables, the ATTACH clause must include the surviving table in the attach list. The attach list is the specified list of tables in the ATTACH clause.

To include a rowid column in the newly-created single, fragmented table, attach all tables first and then add the rowid with the ALTER TABLE statement.