PrepAway - Latest Free Exam Questions & Answers

How can you remove all effects of compression from an index?

How can you remove all effects of compression from an index?

PrepAway - Latest Free Exam Questions & Answers

A.
Execute the ALTER INDEX statement to turn compression off.

B.
Execute the ALTER TABLE statement to turn compression off.

C.
Execute the ALTER INDEX statement to turn compression off; then execute the REORG command to
removed the compression dictionary.

D.
Execute the ALTER TABLE statement to turn compression off; then execute the RUNSTATS command to
tell the DB2 optimizer that compression is no longer used.


Leave a Reply