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;