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

Posted by: Pdfprep Category: C2090-320 Tags: , ,

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: DE

Leave a Reply

Your email address will not be published.