How to view actually executed plan of a procedure call in HANA

[patricksteffens]

From the SQLScript Reference, I know that the execution plan of a procedure can be viewedas follows:

EXPLAIN PLAN SET STATEMENT_NAME = 'test' FOR CALL proc_p1(1);
SELECT * FROM EXPLAIN_CALL_PLANS WHERE STATEMENT_NAME = 'test'

As far as I understand, the explain plan corresponds to the "prepared" plan of PlanViz.

However, the actually executed plan often differs from the prepared one which is why I would like to know whether the executed plan is also stored in a table similar to EXPLAIN_CALL_PLANS.

I know that the "Operator List" view in the PlanViz perspective provides such information. However, I need access to a table or view via SQL. So an explanation of how to query the operator list table in PlanViz would do, too.

[SergioG_TX]

try highlighting the call statement in a sql console - right click - execute/show plan viz --

[patricksteffens]

Hi Sergio,

as I suggested in the question, I know about PlanViz' capabilities and how to use it. What I'm looking for is a table I can query similar to EXPLAIN_CALL_PLANS. I.e. an alternative to the Operator List in PlanViz or a way to access this table from outside PlanViz.