Table Partitioning

Table partitioning can improve performance by dividing large tables into smaller, more manageable storage objects. SAP Sybase IQ 16.0 now supports range, hash, and hash-range partitioning schemes.

Range partitioning divides large tables by a range of partition-key values established for each partition. As part of an information life cycle management strategy, range partitioning can shorten backup and restore times; provide a finer level of granularity for data validation; and support tiered storage.
Hash partitioning maps data to partitions based on partition-key values processed by an internal hashing function. Hash partitioning can enhance join performance on large tables and distributed queries (DQP).
Hash-range partitioning provides the benefits of hash partitioning and range partitioning. Hash partitioning provides the best distributed query performance; range sub-partitioning enhances administrative tasks as part of an information life cycle management strategy.

Note: Range-partitions and composite partitioning schemes, like hash-range partitions, require the separately licensed VLDB Management option.

Additional Information

Administration: Database > Manage SAP Sybase IQ Database Objects > Table Partitions
Administration: Load Management > Bulk Loads with the LOAD TABLE Statement > Considerations for Partitioned Table Loads
Reference: Statements and Options > SQL Statements > ALTER TABLE Statement
Reference: Statements and Options > SQL Statements > CREATE TABLE Statement