Query Plan Analyzer - Overview

Examining SQL can be difficult and requires considerable time and effort to extract crucial information, especially when identifying Many-to-Many (M2M) relationships within the SQL. The SQL's logical plan separates the query into entities such as SELECT, INNER JOIN, FILTER, and AGGREGATE, aiding in comprehending the SQL structure and identifying M2M associations. The Query Plan Analyzer (QPA) is a troubleshooting tool that helps data administrators to better understand the SQL query and to identify M2M relationships within the query. Both Live and ElastiCube models are supported by the QPA. The QPA returns a graph such as the following, which represents the logical plan of the query.