Identifying Table Compression Candidates

Identify the largest user tables based on space reserved, used space, or row count.

Before compressing a user table, identify the largest tables then generate a compression estimate to determine if the table will benefit from compression.

  1. In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Databases > User Databases.
  2. Click the Name field of the database, then click the drop-down arrow and select Properties.
  3. In the left pane, click Usage.
  4. Click the Largest user tables tab.
  5. (Optional) In the View field, click the arrow or enter a number to choose the number of tables to include and click View to update the display.
    You see a list of the largest tables based on the selected criteria.
  6. Select the conditions by which the size of the tables is determined:
    • Rowcount
    • Space reserved
    • Used space
  7. (Optional) Click Compression Advisor to invoke the Compression Advisor wizard.
Parent topic: Manage Table Compression