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;