In SAP HANA Administration Console, open a new SQL console.
Copy and paste the script below into the SQL console.
SELECT 100.00 * SUM(CASE
WHEN P_TYPE LIKE 'PROMO%'
THEN L_EXTENDEDPRICE * (1 - L_DISCOUNT)
ELSE 0
END) / SUM(L_EXTENDEDPRICE * (1 - L_DISCOUNT)) as promo_revenue
FROM
"TPCH"."LINEITEM_DT",
"TPCH"."PART_DT"
WHERE
L_PARTKEY = P_PARTKEY
AND L_SHIPDATE >= '2014-10-01'
AND L_SHIPDATE < '2014-11-01';
Right click inside the SQL console, then select Visualize Plan > Execute. You can also press Ctrl + Shift + X.
In SAP HANA Studio, go to SAP HANA Administration Console. In the Systems tab on the left, double click on the system you are working with.
After the administration console opens, go to the Diagnosis Files tab.
The detailed plan file would have your Dynamic Tiering node as host. You can sort the entries by clicking on the Host header. Click on the Modified header to sort the files by modified date. Find the most recent HTML file with the name similar to “dbo_HANA_ES_###...##.html
”. You can also enter “dbo_HANA_ES_*.html
” into the Filter box. Right click on the file and select Download… to download the file.
In the “Save As” pop up window, select where you want the file to be saved. Then click Save to save the file.
Navigate to the directory where the detailed query plan file is saved and double click to open it using your default web browser.
You should now see the detailed query plan. Scroll toward the end to find Condition 1 Index.
The highlighted index in the query plan below is the Fast Projection (FP) index. The FP indexes are automatically generated for each column in a Dynamic Tiering table. This FP index optimizes projections and enables certain kinds of search conditions to be evaluated. In the absence of any other index, the query plan will normally reference the FP index for the specific column.