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

Hybrid Distribution Scheme (XPS)

A hybrid distribution scheme combines a base strategy and second-level strategy on the same table. The base strategy can be expression-based or range fragmentation. You can use a hybrid distribution scheme to apply different fragmentation strategies on one or two columns.

When you define a hybrid distribution scheme you can specify a single dbslice, a single dbspace, or multiple dbspaces as the storage domain of the fragmentation expression.

The following statement defines a hybrid scheme based on two columns of the table:

CREATE TABLE hybrid_tab (col_1 INT, col_2 DATE, col_3 CHAR(4))
   FRAGMENT BY HYBRID (col_1) EXPRESSION
      col_1 >= 0 AND col_1 < 20 IN dbspace_1,
      col_1 >= 20 AND col_1 < 40 IN dbspace_2,
      col_1 >= 40 IN dbspace_3;
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]