IBM
C2090-312 · Question #100
The EXPLAIN STMTCACHE ALL statement provides information about SQL tuning. Which information is part of the DSN_STATEMENT_CACHE_TABLE?
The correct answer is D. Number of times an SQL statement is executed. See the full explanation below for the reasoning.
Question
The EXPLAIN STMTCACHE ALL statement provides information about SQL tuning. Which information is part of the DSN_STATEMENT_CACHE_TABLE?
Options
- AFilter factor information.
- BStage 1 and stage 2 information.
- CNumber of columns used in an index.
- DNumber of times an SQL statement is executed.
How the community answered
(53 responses)- A2% (1)
- B11% (6)
- C6% (3)
- D81% (43)
Community Discussion
No community discussion yet for this question.