COLUMN STORE¶
The table orientation can be converted from ROW-STORE to COLUMN store using the WITH (ORIENTATION=COLUMN) in the CREATE TABLE statement. This feature can be enabled/disabled using the rowstoreToColumnstore configuration parameter.
Input: CREATE TABLE with change orientation to COLUMN STORE
CREATE MULTISET VOLATILE TABLE tab1
( c1 VARCHAR(30) CHARACTER SET UNICODE
, c2 DATE
, ...
)
PRIMARY INDEX (c1, c2)
ON COMMIT PRESERVE ROWS;
Output:
CREATE LOCAL TEMPORARY TABLE tab1
( c1 VARCHAR(30)
, c2 DATE
, ...
) WITH (ORIENTATION = COLUMN)
ON COMMIT PRESERVE ROWS
DISTRIBUTE BY HASH (c1, c2);