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.