Exam C2090-600 All QuestionsBrowse all questions from this exam
Question 26

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

    Correct Answer: D

    The ANALYZE phase is unique to loading column-organized tables. This phase is responsible for making the loaded data more accessible for query optimization and is not present in other types of tables.

Discussion
meAliOption: D

The ANALYZE phase is only additional phase when using load in column organized tables https://www.ibm.com/support/knowledgecenter/en//SSEPGG_11.1.0/com.ibm.db2.luw.admin.dbobj.doc/doc/t0061530.html