Run the SQL in the Ad Hoc command window to the right.

This steps explains how to turn on automatic table compression.

Create tabe with automatic compression turned on

The first statement creates a new table CUSTOMER_ADDRESS_WITH_AUTO_COMPRESSION with automatic compression turned on. The CUSTOMER_ADDRESS_WITH_AUTO_COMPRESSION table is identical to the CUSTOMER_ADDRESS_WITHOUT_COMPRESSION table except that it will have COMPRESS YES turned on.

All the rows from the original CUSTOMER_ADDRESS_WITHOUT_COMPRESSION table are selected and inserted in the new CUSTOMER_ADDRESS_WITH_AUTO_COMRESSION table.

What happens automatically

When enough new data has been sampled (typically 1 - 2 MB), a compression dictionary is automatically created. Any new incoming data is also compressed automatically. You don't have to run REORG or INSPECT to explicitly create the compression dictionary.