SAP
C_HANASUP_1 · Question #31
You want to investigate a long-running query. How can you generate a graphical view of the cached SQL plan?
The correct answer is A. Right-click on the statement and select Visualize Plan in the SQL Plan Cache tab of the Performance. See the full explanation below for the reasoning.
Question
You want to investigate a long-running query. How can you generate a graphical view of the cached SQL plan?
Options
- ARight-click on the statement and select Visualize Plan in the SQL Plan Cache tab of the Performance
- BAdd a filter to display long-running queries in the SQL Plan Cache tab of the Performance Administration view.
- CSelect the Analysis tab to visualize data in the Data Preview of the long-running query.
- DPaste the long-running query into the SQL Console and double-click it.
How the community answered
(29 responses)- A76% (22)
- B14% (4)
- C7% (2)
- D3% (1)
Community Discussion
No community discussion yet for this question.