Merging a Partition

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. 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. Expand ASE Servers > Schema Objects > Tables, then choose one of:
    • User Tables
    • Proxy Tables
  3. Select the table for the partition.
  4. Select Properties.
  5. Select Partitions.
  6. Click the partitions to merge and select Merge.
  7. Enter the name of the new partition.
  8. (Optional) Select Preview to view the new partition information.
  9. Click OK.
Parent topic: Manage Partitions