Skip to Content
4
Dec 02, 2016 at 07:45 AM

Interpreting the Executed Visualization plan in SAP HANA

903 Views

Hi All,

I have been trying to understand the Visualization plan of a Calculated view to tune it up for better performance. While going through graphical plan, I could find at some nodes, there are huge number of records (about 3 Billion) shown as Output Cardinality Estimated while the actual records returned are only few thousands(Refer picture below). I am confused why so many records are being looked up.

I am looking for answers to following

1. What is the significance of this Estimated cardinality? (Not sure if I have to worry about this as my query is being executed in a minute)

2. Are there any documents to understand how to rightly interpret the Visualization plan?

Attachments

capture.jpg (134.6 kB)