Exam4Training

Assuming you are the SYSADM, what is the effect of executing the EXPLAIN STMTCACHE ALL statement?

Assuming you are the SYSADM, what is the effect of executing the EXPLAIN STMTCACHE ALL statement?
A .  The table DSN_STATEMENT_CACHE_TABLE table contains a row for each SQL statement in the Local Dynamic Statement Cache.
B .  The PLAN_TABLE contains the access path of each SQL statement in the Local Dynamic Statement Cache.
C .  The PLAN_TABLE contains the access path of each SQL statement in the Global Dynamic Statement Cache.
D .  The table DSN_STATEMENT_CACHE_TABLE table contains a row for each SQL statement in the Global Dynamic Statement Cache.

Answer: D

Exit mobile version