The new SQL Analyzer is now available to use with Business Application Studio in addition to the Visual Studio Code plugin. The SQL Analyzer is a tool to visualize and analyze the SQL statement execution plan. The Business Application Studio extension is for SAP HANA Cloud while the Visual Studio Code plugin is for the SAP HANA Platform running on-premise.
First, let me guide you on how to start using the SQL Analyzer from the Business Application Studio.
When creating the SAP HANA Native Application Dev Space enabling the SAP HANA Performance Tools extension as part of the dev space.
It will enable the SQL Analyzer extension as part of Business Application Studio. The SQL Analyzer can be activated from the left menubar
To upload PLV files, we need to create a project folder to upload using the explorer and click the more (…) menu from the PROJECTS which displays the popup menu and select New Folder to create a project folder for PlanViz files.
I will name this folder PlanViz as below
After the folder is created, Use the control (key) + mouse click to display the below popup menu and click upload files and select the PLV file(s) to upload.
The PLV is loaded for plan analysis as shown below.
I will explain how to use the new SQL Analyzer for the next blog.