Merging Partitions

Merging partitions consolidates data from partitions that are accessed infrequently into a single partition. You can merge only list and range partitions.

You can merge any two list partitions, but only adjacent range partitions. The partitions selected to be merged must be on same segment.

Note: You must set the select into/bulkcopy/pllsort database option to true before you merge partitions.

See the Transact-SQL Users Guide for information about partitions.

  1. Expand ASE Servers > Schema Objects > Tables, then choose one of:
    • 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. Click the Name field of the partition, then click the drop-down arrow and select Merge.
  6. In the Marge Partition dialog, enter the name of the destination partition.
  7. (Optional; only for user tables) Select Enable 'online' mode, which improves concurrency and data availability during the merge partition operation
    Enable partition locking must also be enabled.
  8. (Optional) Select Preview to view the new partition information.
  9. Click OK.