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.