Which columns are present in explain plan table of SAP HANA studio?
The columns present in the explain plan table are:
STATEMENT_NAME
SCHEMA_NAME
OPERATOR_NAME
OPERATOR_DETAILS
OPERATOR_ID
TABLE_NAME
TABLE_TYPE
TABLE_SIZE
SUBTREE_COST
EXECUTION_ENGINE
LEVEL
These columns include various details of the SQL statement’s execution plan in explain plan table of SAP HANA studio.