Enabling IBM® DB2 index compression

Enabling index compression on indexes that are part of large Content Platform Engine database tables can improve application response times.

About this task

Complete the following procedure to enable compression on a DB2® index:

Procedure

Run the following command:

ALTER INDEX index_name COMPRESS YES;

Results

The ALTER command (as shown) initiates compression of the specified index.
Note: After a large number of random inserts have been performed, run the REORG INDEX command to keep the compressed index organized.