IBM
C2090-320 · Question #69
Which of the following are contained in the PLAN_TABLE? (Choose two.)
The correct answer is D. Whether an index access or table space scan is used for each access to a table E. The join methods and types that are used, and the order in which DB2 joins the tables. See the full explanation below for the reasoning.
Question
Which of the following are contained in the PLAN_TABLE? (Choose two.)
Options
- ARUNSTATS recommendations
- BAccess to LOB values, which are stored separately from the base table
- CAccess to parent or dependent tables needed to enforce referential constraints
- DWhether an index access or table space scan is used for each access to a table
- EThe join methods and types that are used, and the order in which DB2 joins the tables
How the community answered
(39 responses)- A8% (3)
- B18% (7)
- C3% (1)
- D72% (28)
Community Discussion
No community discussion yet for this question.