Welcome to the ClearSCADA Guide to QueryPad, an SQL query diagnostics tool that is supplied with your ClearSCADA software solution. In this Guide, we will explain how to use QueryPad to test your SQL queries and improve their efficiency.
QueryPad is an application that runs independently of ViewX and it provides diagnostic information about your SQL query. By examining the diagnostics information, you can see how the Query Processor (used to process SQL queries in ClearSCADA) handles your query, and use that information to determine whether your query could be changed to work more efficiently.
In the QueryPad Guide, we describe how to run, connect, and use the diagnostic features of the QueryPad application. We also provide information about the various phases of the Query Processor’s processing, as to make effective use of the QueryPad diagnostics, you will need to understand how the Query Processor processes queries.
For information on running and using QueryPad, refer to:
For information on the various phases undertaken by the Query Processor when you submit an SQL query, refer to the ClearSCADA Guide to SQL.