How can you remove all effects of compression from an index?
A.
Execute the ALTER TABLE statement to turn compression off.
B.
Execute the ALTER INDEX statement to turn compression off; then execute the REORG
command to removed the compression dictionary.
C.
Execute the ALTER INDEX statement to turn compression off.
D.
Execute the ALTER TABLE statement to turn compression off; then execute the
RUNSTATS command to tell the DB2 optimizer thatcompression is no longer used.
Explanation:
COMPRESS NO or COMPRESS YES
Specifies whether the index data will be compressed. If the index is partitioned, this option will apply to all partitions.
When an index is changed from one compression option to another (either from COMPRESS YES to COMPRESS NO, or from COMPRESS NO to COMPRESS YES), the index is marked as rebuild pending. For a non-partitioned index, the index will be placed in a page set rebuilding state. For a partitioned index, the index will be placed in rebuilding state.
0
0