Partitioning Tab

To enable partitioning for your table, check the Enable Partitioning check box. This enables the partitioning options (shown in the figure that follows).

Figure 8.18 The Partitioning Tab

Content is described in the surrounding text.

The Partition By pop-up menu displays the types of partitions you can create:

  • HASH


  • KEY



  • LIST

Use the Parameters field to define any parameters to be supplied to the partitioning function, such as an integer column value.

Choose the number of partitions from the Partition Count list. To manually configure your partitions, check the Manual check box. This enables entry of values into the partition configuration table. The entries in this table are:

  • Partition

  • Values

  • Data Directory

  • Index Directory

  • Min Rows

  • Max Rows

  • Comment

Subpartitioning is also available. For more information about partitioning, see Partitioning.