SAP HANA SQL执行计划(SAP HANA SQL explain plan)

SAP HANA SQL执行计划:

方法一：直接写执行语句

explain plan SET STATEMENT_NAME = 'select_emp' FOR select ename,sal,hiredate from emp where hiredate > '1980-12-17' and hiredate < '1981-11-17';

方法二：

在SAP HANA Studio中打开SQL EDIT 选中要执行的SQL 语句,右键选择Explain plan. sap HANA 会帮您生成

EXPLAIN PLAN FOR

select ename,sal,hiredate from emp where hiredate > '1980-12-17' and hiredate < '1981-11-17'；语句去执行

EXPLAIN_PLAN_TABLE