Which of the following are contained in the PLAN_TABLE? (Choose two.)

Which of the following are contained in the PLAN_TABLE? (Choose two.)
A . RUNSTATS recommendations
B . Access to LOB values, which are stored separately from the base table
C . Access to parent or dependent tables needed to enforce referential constraints
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

Answer: D,E

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments