Identical Segmentation

When performing an INSERT-SELECT operation from a segmented source table to a segmented destination table, segment both projections on the same column to avoid resegmenting the data, as in the following example:

CREATE TABLE source (col1 INT, col2 INT, col3 INT); 
CREATE PROJECTION source_p (col1, col2, col3) AS 
   SELECT col1, col2, col3 FROM source 
   SEGMENTED BY HASH(col3) ALL NODES; 
CREATE TABLE destination (col1 INT, col2 INT, col3 INT); 
CREATE PROJECTION destination_p (col1, col2, col3) AS 
    SELECT col1, col2, col3 FROM destination 
    SEGMENTED BY HASH(col3) ALL NODES; 
INSERT /*+direct*/ INTO destination SELECT * FROM source;