Skip to Content
0

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

Feb 23 at 10:00 AM

131

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sergio Guerrero Feb 23 at 11:59 AM
-2

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

Show 1 Share
10 |10000 characters needed characters left 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.

0