Query Plan Analyzer - Benefits

Previous Functionality

In the past, Sisense provided the JAQLine add-on to analyze SQLs and detect Many-to-Many (M2M) 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.

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.