Using a Hash Partition

Create a new partition or change an existing partition using a strategy of a system-generated hashing function.

1. In the Perspective Resources view, select the server on which the table resides, then click the drop-down arrow next to the server name and select Administration Console.
2. In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Tables, then choose one of the following:
   • User Tables
   • Proxy Tables
3. Select the table for the partition.
4. Select Properties.
5. Select Partitions.
6. Choose to create a new partition or change an existing partition.
7. In the Select Partition Strategy window, choose the partitioning strategy Hash.
8. (Optionally) Specify the number of partitions.
9. In the Select Partition Key Columns window, use the arrow buttons to select partition key columns.
   Partition key columns are table columns that determine how the table is to be partitioned.
10. In the Partition Specification window, specify the name of the partition where the partition will reside.
11. (Optional) Click Summary to verify your selected options.