Execution history in SQL Complete

May 2nd, 2019

dbForge SQL Complete includes the whole range of options that provide possibilities for powerful optimization and great performance increase. Execution history is an important part of this list. It is included into the Standard and Express edition package. The feature stores basic information about executed SQL statements for a certain period. With the help of this option, the user can view, edit and search for queries that were executed in the database easily. However, the information above describes only the basic functionality. Let’s discover what else this feature is possible to do.

Main features

Success verification check

This option allows checking whether the SQL statements was successfully executed or not. Each query in the table has the field with an icon that displays the result of the execution. You can also sort the table entries by this parameter.

execution_status

Log output range

Execution history provides the ability to set the date interval in which queries were output. You can view the entire list for any period, just set any time range you need.

result_range

Group by column

This option allows grouping the completed statements by any desired column from the table. To do this, just drag the selected column to the panel above the list. Execution history will display the results immediately.

group_history

Open in a new SQL window or copy to clipboard

Each user can get access to any SQL statement from the archive to view its code to perform any changes after. It’s only necessary to right-click on the certain request and select the “To New SQL Window” or “To Clipboard” option.

to-new-sql_window

 

Statements sorting

The feature provides opportunities for various sorting of executed statements. You can sort the archive by any column that is present in the table. To do this, it is just enough to click on the header of the required one.

sort_result

Detailed item info

The execution history feature has a convenient interface for getting all the necessary information about each statement. You can sort info by each parameter field as well as perform the customization of the displayed columns. Just select the Column Chooser menu item after the right-click on any free space in the grid header and drag&drop the columns.

Customization_window

Search filter

The feature allows filtering executed statements by text key entry. This option will be very useful for DBAs who often have to work with a large number of requests. Simply enter the certain characters in the “Search” field and the Execution History will immediately display the desired result.

filter1

Conclusion

Execution history is a powerful feature that provides a whole set of tools for working with already executed statements. It will definitely be useful for all DBAs who often have to work with databases backlog or with its backups.

 

Leave a Comment