Knowledge quiz

It's time to put what you've learned to the test, get 8 right to pass this week.

Assume you have already collected "Explain Plan for CALL" for your SQLScript procedure "P1()" with statement name "P1". Which SQL statement should you execute to see its "Explain Plan for CALL" result?

Choose the correct answer.

SELECT * from M_SQLSCRIPT_PLAN_PROFILER_RESULTS WHERE PROCEDURE_NAME = 'P1';

SELECT * from M_ACTIVE_PROCEDURES WHERE PROCEDURE_NAME = 'P1';

SELECT * from EXPLAIN_CALL_PLANS WHERE STATEMENT_NAME = 'P1';

SELECT * from EXPLAIN_PLAN_TABLE WHERE STATEMENT_NAME = 'P1';

Which of the following statements about M_ACTIVE_PROCEDURES are correct?

There are two correct answers.

M_ACTIVE_PROCEDURES can be used to check the execution of the inner SQL statements of a SQLScript procedure.

M_ACTIVE_PROCEDURES can be used to check an execution plan of a SQLScript procedure.

M_ACTIVE_PROCEDURES can be used to check the execution of control-flow statements of a SQLScript procedure.

M_ACTIVE_PROCEDURES shows no information the inner SQL statements of a SQLScript procedure that have not yet been executed.

Which of the following statements about SQL Trace are correct?

There are three correct answers.

SQL Trace is recommended to check inner SQL statements reshaped by the SQLScript Optimizer.

SQL Trace is recommended to find out which of the inner SQL statements consumes higher memory or runs slowly.

SQL Trace is recommended to check each query plan of the executed inner SQL statements and their results.

SQL Trace is recommended to check the execution plan of a SQLScript procedure without actual execution.

SQL Trace is recommended to find out how control-flow statements are executed.

Which statements about Explain Plan for CALL are correct?

There are two correct answers.

An execution plan of a SQLScript procedure is shown in the EXPLAIN_PLAN_TABLE table.

Explain Plan for CALL collects information about an execution plan of a SQLScript procedure after executing it.

Explain Plan for CALL shows an execution plan of a SQLScript procedure.

Explain Plan for CALL does not show a query plan (Explain Plan) of inner SQL statements.

Which tools can visualize Plan Visualizer trace?

There are two correct answers.

SAP HANA Studio - PlanViz perspective

SAP HANA SQL analyzer tool

SAP Analysis for Microsoft Office

SAP GUI

Which of the following statements about the SQLScript Plan Profiler are correct?

There are two correct answers.

The profile result is not collected when the CALL statement of the SQLScript procedure is cancelled.

The SQLScript Plan Profiler only shows how control-flow statements are executed. It does not show any information about the execution of the SQL statement in the SQLScript procedure.

The SQLScript Plan Profiler is helpful in finding out which part of the code consumes the most memory or is running slowly.

The SQLScript Plan Profiler is triggered only by using a SQL hint.

Assume your connection ID is "12345", your database username is "HANA", and your procedure name is "P1()". What are the correct SQL statements to start the SQLScript Plan Profiler?

There are three correct answers.

ALTER SYSTEM START SQLSCRIPT PLAN PROFILER;

ALTER SYSTEM START SQLSCRIPT PLAN PROFILER FOR SESSION 12345;

ALTER SYSTEM START SQLSCRIPT PLAN PROFILER FOR PROCEDURE P1;

ALTER SYSTEM START SQLSCRIPT PLAN PROFILER FOR CONNECTION 12345;

ALTER SYSTEM START SQLSCRIPT PLAN PROFILER FOR USER HANA;

What are some of the things you can see on the OVERVIEW page of the SAP HANA SQL analyzer tool?

There are three correct answers.

Execution summary

Dominant plan operators

System information

Parameter values

SQL statement

Which SQLScript supportability features check the execution of control-flow statements of a SQLScript procedure?

There are two correct answers.

SQL Trace

Explain Plan for CALL

M_ACTIVE_PROCEDURES

SQLScript Plan Profiler

Plan Visualizer for SQLScript

10.

Which SQLScript supportability features can check an execution plan of a SQLScript procedure?

There are three correct answers.

SQL Trace

Explain Plan for CALL

M_ACTIVE_PROCEDURES

Plan Visualizer for SQLScript

SQLScript Plan Profiler