Run the SQL in the Ad Hoc command window to the right.
This steps explains how to turn on automatic table compression.
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.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.