Subpartition Editor
Go Up to Partitioning a Table
In the Subpartition Editor, select the Subpartition Type. Options include:
- Hash. Hash partitioning distributes data based on the result of running the partitioning key through a hashing algorithm.
- List. List partitioning maps rows to partitions based on discrete values.
- Range. Range partitioning distributes data based on a given range, as in time intervals.
On the Columns tab, move the appropriate columns from the Available Columns list to the Selected Columns list to work with those columns.
| Name | Description |
|---|---|
| Hash | Use Hash partitioning to evenly distribute data.
|
| List | Use List partitioning to control how rows map to each partition based on discrete values. |
| Range | Use Range partitioning to periodically load new data and purge old data. |