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?
