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?