Enabling index compression on indexes that are part of
large Content Platform Engine database
tables can improve application response times.
Complete the following procedure to enable compression on
a DB2® index:
Run the following command: ALTER
INDEX index_name COMPRESS YES;
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.