SAP
C_HANAIMP151 · Question #266
How can you analyze a performance issue in the execution of an SQL statement using the SQL Console? (Choose two)
The correct answer is C. Use the Explain Plan command from the right-click menu in the SQL Console. D. Use EXPLAIN PLAN in the SQL statement and query the EXPLAIN_PLAN_TABL. See the full explanation below for the reasoning.
Question
How can you analyze a performance issue in the execution of an SQL statement using the SQL Console? (Choose two)
Options
- AUse the Prepare Statement command from the right-click menu in the SQL Console.
- BQuery the table "SYS"."CACHE_P_QUERIES_"' after the execution of the SQL statement.
- CUse the Explain Plan command from the right-click menu in the SQL Console.
- DUse EXPLAIN PLAN in the SQL statement and query the EXPLAIN_PLAN_TABL
How the community answered
(54 responses)- A19% (10)
- B7% (4)
- C74% (40)
Community Discussion
No community discussion yet for this question.