IBM
A2090-614 · Question #89
Given the following output: Which Explain procedure can be used to find the most expensive SQL statement in terms of CPU cost over a period of time?
The correct answer is B. EXPLAIN_FROM_ACTIVITY. See the full explanation below for the reasoning.
Question
Given the following output:
Which Explain procedure can be used to find the most expensive SQL statement in terms of CPU cost over a period of time?
Options
- AEXPLAIN_FROM_DATA
- BEXPLAIN_FROM_ACTIVITY
- CEXPLAIN_FROM_SECTION
- DEXPLAIN_FROM_CATALOG
How the community answered
(41 responses)- A2% (1)
- B71% (29)
- C10% (4)
- D17% (7)
Community Discussion
No community discussion yet for this question.