The following EXPLAIN functionalities exist:
Command: EXPLAIN PLAN FOR <sql_statement>
Details: Generation of explain plan for explicitly specified SQL statement <sql_statement>
Command: EXPLAIN PLAN FOR SQL PLAN CACHE ENTRY <plan_id>
Rev.: >= 90
Details: Generation of explain plan for SQL statement with PLAN_ID <plan_id> in M_SQL_PLAN_CACHE
This option is helpful to understand why a previously recorded SQL statement shows a different performance than current executions.
Results of these commands are written to the EXPLAIN_PLAN_TABLE. Among others, you can use SQL: "HANA_SQL_ExplainPlan" (SAP 1969700) to evaluate the results.
In order to identify the proper entries in EXPLAIN_PLAN_TABLE, you can use "EXPLAIN PLAN SET STATEMENT_NAME = '<statement_name>' ..." when generating the explain plan. Then you can check EXPLAIN_PLAN_TABLE for entries related to <statement_name>.