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