What information can you find in the Plan Graph?

The Plan Graph provides an extensive visualization of the execution plan for SQL queries in the SAP HANA database. When analyzing the Plan Graph, one can observe various steps that the execution plan goes through, including data retrieval and transformation processes.

One significant aspect captured in the Plan Graph is the number of records returned at each step. This information is invaluable for understanding how data flows through the execution plan and helps identify potential bottlenecks. For example, if a particular step returns a significantly higher or lower number of records than expected, it can indicate areas in need of optimization or further investigation.

While there are other details related to execution engines, execution time, and the SQL Plan Cache that provide additional insights into the query performance and optimization opportunities, they are not directly visible in the Plan Graph in the same way that the number of records returned is. Understanding the number of records returned is crucial for diagnosing performance issues and ensuring that the query performs efficiently.