Overview

In this document, we are going to review the Query Analyzer tool on Wayfast. This can be used to monitor SQL queries and can help developers to create or edit database objects (functions, views, jobs, partitions, stored procedures) for improving database performance inside the Wayfast application in case that we don’t have the SQL Server installed in our environment.

How to use the Query Analyzer in Wayfast?

In Wayfast, turn to “Database” header icon and click “Query Analyzer” tab

A new tab is opened on the browser, we can observe a navigation bar at the left. This contains 3 dropdown filters that we can use to select the Database and the corresponding Tables associated.

You are now ready to write SQL queries against your database. You can use this interface to create database objects, insert data into a database table, select data, update data, delete data. Once the statement is made, click “Execute” button to run the script or “Synchronize” in case you need to update something that was modified in Database and you want to include in Wayfast.

Access to Query Analyzer from different sections in Wayfast

In the previous tutorials related to functions, views, jobs, partitions and stored procedures, we observed that there are links to “Edit Script” or “View Script”. These features are redirecting to the query analyzer and display the statements from SQL into Wayfast.

In this example, under Stored Procedure’s dashboard, we can click on lookup icon and it will open automatically the Query Analyzer

Recap

In this document, we knew the Query Analyzer in Wayfast that acts as an interface for running SQL queries against your database. You can use it to create and run adhoc scripts, or you can create SQL scripts and save them for later use.