Skip to Content
0
Jun 07, 2016 at 04:18 AM

HANA Query Plan Execution Analysis

1821 Views

Hi,

Do we have any SAP published document or any other blog post which explains how to read and analyze the query plan execution on HANA.

I have created execution plan on 1 complex query and have few doubts

1) The Time section of execution plan has Execution time 4986.2s which is around 1.5 hour but the query execution doesn't take that long when we execute on the SQL console. What does the Execution Time represents?

2) Analytical Search is the top dominant Operator

When I further get into details of "Analytical Search", I got below details but not sure how to interpret them

3) In the "Executed Plan" tab I see all the boxes in different color borders (Pink, Yellow, Green, blue, red) and Arrows (grey, orange). Are those colors have any importance in the analysis?

4) Each box in the "Executed Plan" tab has "Inclusive time" and "Exclusive time". What are they?

5) What is SUBTREE_COST in the query Explain plan?

it will be really helpful if any of you can help in above queries or anyone provide any document that explains my questions

Cheers,

Ashok

Attachments