Modifying Schema, View, Table, and Routine Definitions › Maintaining Tables › Adding or Removing Data Compression

Adding or Removing Data Compression

Drop/Add Table

To add or remove compression, you must drop and redefine the table, as described in 30.5, “Dropping and Recreating a Table”. When redefining the table, add or remove the COMPRESS clause as desired.

Considerations

• By removing compression, the table will occupy more space in the database and may overflow a database that is already near capacity
• By adding compression, you may incur a modest increase in CPU time during subsequent DML processing of the table

Note: For more information about data compression, see the CA IDMS Presspack User Guide.