Skip to Content

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 23 at 11:59 AM
    -2

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

    Add comment
    10|10000 characters needed characters exceeded

    • 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.