DB2 10 for z/OS Database Administrator — Question 16

Which of the following statements about compression for BLU MPP tables is TRUE?

Answer options

• A. Compression must be explicitly enabled for BLU MPP tables
• B. Compression requires decompression to evaluate partition joins
• C. Unique compression dictionaries are generated for each partition
• D. Each table has a single compression dictionary that gets replicated across all partitions

Correct answer: D

Explanation

The correct answer is D because in BLU MPP tables, a single compression dictionary is utilized across all partitions, optimizing storage and performance. Option A is incorrect as compression is enabled by default, while B is incorrect because decompression is not required for evaluating partition joins. Option C is also wrong since unique dictionaries are not generated for each partition.