Creating a Hash Partition

Hash partitioning distributes table data to logical partitions for parallel execution, which can enhance join performance on large tables and distributed queries. Hash partitioning maps data to partitions based on partition key values processed by an internal hashing function.

Prerequisites

Database Version	Table Partition Privileges
SAP Sybase IQ 15.3 and 15.4	Table owned by self – None required. Table owned by other users – Requires one of: DBA authority. ALTER permission on the table.
SAP Sybase IQ 16.0	Requires one of the following: ALTER ANY OBJECT system privilege. CREATE permission on the dbspace along with one of: ALTER ANY TABLE system privilege. ALTER permission on the table. You own the table.

The SAP Sybase IQ resource is authenticated and running.
In a multiplex configuration, the coordinator node is running.
You are licensed for the Very Large Database Management option (IQ_VLDBMGMT).
The table to be partitioned is empty.

Task

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the Administration Console, expand IQ Servers > Schema Objects > Tables.
Select Tables, select the table in the right pane, click the drop-down arrow that appears beside the table name, and select Properties.
Select Partitions and click New.
The Create Partition Wizard appears.
On the Partition Type tab, specify a hash partition:

Option Description

What type of partition do you want to create? Select Hash.
Click Next.

Hash partition keys are restricted to a maximum of eight columns with a combined declared column width of 5300 bytes or less. You declare the partition key columns; the number and location of the partitions are declared internally.

Partition keys can contain NULL and DEFAULT values. All NULL values are mapped to the same hash partition.
Select one or more table columns and click Add. To remove an added column, select it and click Remove.

Tip: Use Shift-click or Control-click to select multiple columns.
Click Finish.
Click Apply or OK.