nerdexam
SAP

C_HANATEC142 · Question #77

You are reviewing the execution plan of an SQL statement. You want to find out which plan operators (POPs) have been executed in parallel and for how long each of them has been active. How can you…

The correct answer is A. Use the Visualize Plan functionality in the SAP HANA studio. See the full explanation below for the reasoning.

Question

You are reviewing the execution plan of an SQL statement. You want to find out which plan operators (POPs) have been executed in parallel and for how long each of them has been active. How can you accomplish this? Please choose the correct answer.

Options

  • AUse the Visualize Plan functionality in the SAP HANA studio.
  • BUse Job Progress in the SAP HANA studio.
  • CUse Performance Trace in HDB admin.
  • DUse EXPLAIN (graphically) in the DBA Cockpit.

How the community answered

(26 responses)
  • A
    73% (19)
  • B
    4% (1)
  • C
    8% (2)
  • D
    15% (4)

Community Discussion

No community discussion yet for this question.

Full C_HANATEC142 Practice