SAP
C_HANAIMP142 · 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
(56 responses)- A7% (4)
- B11% (6)
- C82% (46)
Community Discussion
No community discussion yet for this question.