SQL Reference Guide > SQL Reference Guide > SQL Statements > SET > [NO]PARTITION_SCHEME
Was this helpful?
[NO]PARTITION_SCHEME
SET PARTITION_SCHEME automatically assigns a partition scheme to an X100 table created by the CREATE TABLE statement. It overrides the x100_partition_scheme config.dat parameter for the session. Valid values are:
• NONE - No partitioning.
• HASH - Hash partitioning on the first column of the table.
• AUTO - Automatic partitioning.
SET NOPARITION_SCHEME removes the session setting and uses the system default.
Last modified date: 08/14/2024