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. Select ASE Servers > Schema Objects > Tables, then choose one of the following:
    • User Tables
    • Proxy Tables
  2. Select the table to be placed on a segment.
  3. Select Properties.
  4. Click Usage.
  5. Select the segment to on which to place the table.
  6. (Optionally) Select the type of unit measurement to view used and available space of the segment.