Using a Hash Partition

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

Note: To create hash, list, or range partitions, you must first enable semantic partitioning.
  1. In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Tables, then choose one of the following:
    • User Tables
    • Proxy Tables
  2. Click the Name field of the table, then click the drop-down arrow and select Properties.
  3. In the left pane, click Partitions.
  4. Click the drop-down arrow and select New, or choose to an existing partition from the right pane.
  5. In the Select Partition Strategy screen:
    1. Choose the partitioning strategy Hash.
    2. (Optionally) Specify the number of partitions.
  6. In the Select Partition Key Columns screen, use the arrow buttons to select partition key columns.
    Partition key columns are table columns that determine how the table is to be partitioned.
  7. In the Partition Specification screen, specify the name of the partition and where the partition will reside.
  8. (Optional) Click Summary to review your selected options.