Multiple choice technology databases

Which table gives access path information for a plan/query when EXPLAIN command is used

  1. DSN_STATEMNT_TABLE

  2. PLAN_TABLE

  3. SYSPLAN

  4. SYSPACKAGE
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The DB2/SQL EXPLAIN statement inserts detailed information about the access path of the query being explained into a table named PLAN_TABLE. DSN_STATEMNT_TABLE contains cost estimates, while SYSPLAN and SYSPACKAGE are catalog tables storing plan and package metadata rather than explain output.

Keep practicing — related questions