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