Lets you create a PARTITION BY RANGE statement similar to the following:
CREATE TABLE orders (id INT, shipdate DATE, ...)
PARTITION BY RANGE(shipdate)
(
STARTING '1/1/2006' ENDING '12/31/2006'
EVERY 3 MONTHS
)
● Partitions: Displays existing partitions. If more than one column is used to create the partition, the ending values of the partition keys (columns) are listed in the End Value column in the same order as the columns in the partition definition. You can change the partition definition by selecting the partition and then changing the Start Value in the Partition Definition area.
● Name: Lets you define the name of the partition. This field is not used when creating several partitions automatically. Use the Range Width and Duration Label fields to create a range partitioning statement such as EVERY 3 MONTHS.
● Column Name: Displays the column names selected to be part of the partition on the Partitions tab.
● Start Value: Lets you specify the earliest possible date or time, or the lowest integer to include in the partition. In the partitioning statement, the start value is the STARTING FROM value.
A date string can be specified using one of the following formats:
• yyyy-mm-dd
• mm/dd/yyyy
• dd.mm.yyyy
A timestamp string can specified as:
• yyyy-mm-dd hh.mm.ss.nnnnnn
• yyyy-mm-dd-hh.mm.ss.nnnnnn
You can also choose MINVALUE or MAXVALUE from the list, the values of which depend upon the datatype.After specifying the Start Value, specify the End Value.
● Start Value Inclusive: Select to include the specified start value in the partition. Keywords inserted are INCLUSIVE IN. If not selected, the partition will start at the value just greater than the specified start value, and the keywords inserted will be EXCLUSIVE IN.
● End Value: Lets you specify the latest possible date/time or the largest integer to include in the partition. When working with a date-partitioned table, this would be the ENDING value. See Start Value above for acceptable formats for date and time stamp strings.
● End Value Inclusive: Select to include the specified end value in the partition. Keywords inserted are INCLUSIVE IN. If not selected, the partition will end at the date/time or integer just greater than the specified end value, and the keywords inserted will be EXCLUSIVE IN.
● Range Width: Use Range Width and Duration Label to automatically create multiple partitions. The Range Width is the date, time or integer interval used to partition the table. For example, in the EVERY 3 MONTHS clause, the Range Width is 3.
● Duration Label: From the list, select the unit of measure to use to partition the table. In the EVERY 3 MONTHS clause, the Duration Label is MONTHS. For an integer-partitioned table, select (none) as the duration label.
● Tablespace: Specifies the tablespace where the partition is stored.
● LONG IN: Lets you specify a large tablespace where long data is to be stored. Large objects are by default stored in the same tablespace as the corresponding data objects, whether the partitioned table uses only one tablespace or multiple tablespaces. The LONG IN clause overrides this default behavior, causing long data to be stored in the tablespace specified, which can improve database performance.