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: