Skip to Content
0
Jul 01, 2019 at 07:45 AM

How to check Explain Plan of a Stored Procedure in Hana SPS12

173 Views

How to check Explain Plan for Stored Procedure in Hana SPS12?

I came across this command while reading the documentation :


Statement 1:

EXPLAIN PLAN SET STATEMENT_NAME = 'test' FOR CALL proc_p1(1);

Statement 2:

SELECT * FROM EXPLAIN_CALL_PLANS WHERE STATEMENT_NAME = 'test';

They give below errors :

Error 1 :

SAP DBTech JDBC: [7]: feature not supported: cannot explain plan for call statement

Error 2:

Could not find table/view EXPLAIN_CALL_PLANS in schema HADMIN

I guess this feature is not supported in HANA SPS12.

Is there any alternate solution to get similar results?