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 on first column
auto
Automatic partitioning
system
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/06/2024