# Query Plan Analyzer - Benefits

> QPA benefits. The Query Plan Analyzer (QPA) returns a graph describing the SQL and also detects M2M relationships.

*Source: https://docs.sisense.com/main/SisenseLinux/qpa-benefits.htm*

---

Last updated: June 11, 2026

|  |  |
| --- | --- |
| [Tier](https://www.sisense.com/pricing/#pricing) | [Deployment](https://docs.sisense.com/main/SisenseLinux/introduction-to-sisense-cloud-managed-services.md#ComparisonofManagedCloudandSelfHosted) |
| Launch     Grow    Enterprise | Cloud     On-Prem |

## Previous Functionality

In the past, Sisense provided the [JAQLine](https://www.sisense.com/marketplace/visualize-queries/) add-on to analyze SQLs and detect [Many-to-Many (M2M)](https://docs.sisense.com/main/SisenseLinux/data-model-building-practices.md#TableRelationships) relationships. While this solution worked, it had some drawbacks:

- The calculations it performed were made in place, meaning that it could take a considerable amount of time to receive a response.
- In some use cases, the results were not accurate.
- It only worked for the old translator engine.

**Note:** While the JAQline add-on is still available for customer use, it is no longer actively supported or maintained by Sisense.

## New Functionality

The Query Plan Analyzer (QPA) returns a graph describing the SQL and also detects M2M relationships.

![QPA graph](https://docs.sisense.com/main/Resources/Images/QPA-graph2.png)

### Benefits

- **Works for New Analytical Engines** - Unlike JAQLine, which did not work for the New Analytical Engine, the QPA works for the New Analytical Engine.
- **Faster response time** - Unlike JAQLine, the Query Plan Analyzer uses statistics that were collected in the build process / after publishing a live model, and does not calculate them on every usage. Therefore, the experience is much smoother and faster.
- **Shows a graph structure that represents the SQL query** - Unlike JAQLine, which only showed the connection between the tables, the Query Plan Analyzer details all of the SQL actions in a graph.