Query Analyzer Tool

Query Analyzer Tool is a simple-to-use software application that, as the name says, enables you to verify SQL queries when it comes to execution plans, in order to make sure that everything is in working order. It is similar to SQL Server Query Analyzer.

The program is quickly installed and wrapped in a user-friendly interface, made from a single window with an intuitive structure. The first step is connecting to an SQL server by specifying its name, database and connection method between Windows and SQL Server authentication.

It is possible to find out the number of tables used in a query and total rows for each one, as well as to view the indexes of a table. Query Analyzer Tool integrates a simple editor that allows you to modify information, use a search function, set bookmarks (up to 10) and quickly select them via hotkeys, and spot brackets by color.

The font can be increased or decreased in size, while information can be exported to spreadsheets (XLS), CSV or text documents (TXT) for closer examination. Query Analyzer Tool lets you indicate the lock report and user activity scripts, search path, DMO timeout, editor font size, and row count difference.

No error dialogs were shown in our tests, and the app did not hang or crash. It has a good response time and minimal impact on computer performance, since it runs on low CPU and RAM. Although, Query Analyzer Tool does not bring new features to the table, it provides users with a fact and effective solution to exploring and verifying SQL queries.