SQL Language Guide > SQL Language Guide > SQL Statements > CREATE TABLE > Default Distribution Scheme
Was this helpful?
Default Distribution Scheme
You can assign a default distribution scheme to be used when creating partitioned tables. The default scheme corresponds to the DBMS configuration parameter x100_partition_scheme in config.dat. Valid values are:
HASH
Hash partitioning on the first column of the table.
AUTO
Automatic partitioning.
NONE
No partitioning.
The number of partitions used is the default_npartitions setting in config.dat. If it is equal to 1, partitioning is not done.
The default distribution setting can be overridden at the session level using the SET PARTITION_SCHEME statement.
Last modified date: 12/19/2024