Glossary

PLAN_TABLE

the classic access path table, one row per query block per table access - **DSN_STATEMNT_TABLE** — statement-level cost estimates (DB2 V8+), the single most useful performance diagnostic table - **DSN_FUNCTION_TABLE** — function-level detail for queries with subqueries, UNIONs, and other multi-step

Learn More

Related Terms