Table Partitions

Dividing large tables into more manageable storage objects, called partitions, can improve shorten backup and restore times, provide a finer level of granularity for data validation, and support tiered storage.

Partitions share the logical attributes of the parent table. Manage partitions individually by placing them in separate dbspaces.

Three are three types of partitions: hash, range, and hash-range. Only a range partition can be added to an existing table in the IQ main store. Hash and hash-range partitions can only be added during the initial creation of the IQ main store table. Range partitioning can be added to both new and existing tables. For tables with existing range or hash-range partitioning, additional range subpartitions can be added as needed.

You cannot partition an IQ catalog (system) store table.

• Creating a Range Partition on an Existing Table
  You can add range partitioning to an existing unpartitioned table or add additional range partitions to a table that is already range partitioned.
• Creating a Range Subpartition to an Existing Hash-Range Partitioned Table
  On an existing table with hash-range partitioning, you can add additional range subpartitions. You cannot add Hash-range partitioning to an existing unpartitioned table.
• Deleting a Range Partition or Subpartition
  Remove one or more range partitions or subpartitions from a table. You cannot delete the last remaining partition on a table. Use Unpartition instead.
• Unpartitioning a Table
  Remove all partitioning from a table, preserving the data in the table.
• Rebuilding a Hash or Hash-Range Partitioned Table
  Once a table with hash or hash-range partitioning is unpartitioned, it can only be repartitioned by range. Hash and hash-range partitioning on an existing table is not supported.
• Merging Partitions
  Merge adjacent range partitions or subpartitions in a table.
• Splitting a Partition
  Split a range or hash-range partition in a table.
• Moving a Partition
  Move a range or hash-range partition to another dbspace.
• Managing Column Storage in a Table Partition
  Store data for individual columns in a range or hash-range partition separately from the dbspace for the partition. You can add, delete and move columns within the partition to specific dbspaces.
• Viewing or Modifying Table Partition Properties
  View table partition details or change the table partition details and definition of an existing table partition.
• Table Partition Privilege Summary
  A list of the system privileges and object permissions required to complete the various table partition tasks.