Overview
In this documentlesson, we are going to will review the Query Analyzer tool on Wayfast. This can be used to monitor SQL queries and it 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 . This is very helpful on those cases where developers don’t have the SQL Server installed in our the environment.
How to use the Query Analyzer in Wayfast?
In Wayfast, turn to “Database” header icon at top menu and click on “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 We are now ready to write SQL queries against your database. You We 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 on “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 lessons related to functions, views, jobs, partitions and stored procedures, we observed that there are links to “Edit Script” or “View Script”. These features options are redirecting to the query analyzer and display they are displaying the statements from SQL into Wayfast.
...
| Note |
|---|
“Execute” button will be available depending on the access credentials for each specific Wayfast user |
Recap
In this documentlesson, we knew learnt about the Query Analyzer in Wayfast and we realize that this tool acts as an interface for running to run SQL queries against your our own database. You We can use it to create and run adhoc scripts, or you we can create new SQL scripts and save them for later use.