DB2 10 for z/OS Database Administrator — Question 54

Which phase of the LOAD utility is unique to loading column organized tables?

Answer options

• A. LOAD
• B. BUILD
• C. DELETE
• D. ANALYZE

Correct answer: D

Explanation

The ANALYZE phase is essential for column-organized tables because it helps to gather statistics that optimize query performance. The other options—LOAD, BUILD, and DELETE—do not pertain specifically to column-organized tables or their unique requirements during the loading process.