Placing a Table on a Segment

Using a segment to put a table on a specific database device can improve Adaptive Server performance and give increased control over placement, size, and space usage of database objects.

  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 to be placed on a segment.
  4. Select Properties.
  5. Click Usage.
  6. Select the segment to on which to place the table.
  7. (Optionally) Select the type of unit measurement to view used and available space of the segment.
Parent topic: Manage Tables