Regarding EXPLAIN PLAN in sap HANA

[Former Member]

Hi ,

can any please give me one example what is the use of in SAP HANA.I have checked the below link but could not able to understand .

EXPLAIN PLAN - SAP HANA SQL and System Views Reference - SAP Library

EXPLAIN PLAN

[former_member183326]

Hello,

The EXPLAIN PLAN statement is used to evaluate the execution plan that the SAP HANA database follows to execute an SQL statement. Using this command, a user can see the execution plan of a subquery, or that of an entry already in sql plan cache. The result of the evaluation is stored into the EXPLAIN_PLAN_TABLE view for examination.

More information here:

http://help.sap.com/hana/SAP_HANA_SQL_and_System_Views_Reference_en.pdf