QueryPad is an SQL query diagnostics tool that runs independently of ViewX and is supplied as part of your ClearSCADA software solution. It allows you to test your SQL queries and provides details that may help you to improve the efficiency of your queries (and therefore improve performance).
In this section, we explain how to:
- Display QueryPad
- Connect QueryPad to a Database
- Define whether QueryPad Displays the Results of your SQL Query
- Add your SQL Query to QueryPad
- Run your Query in QueryPad
- Use the QueryPad diagnostics (see Understanding the QueryPad Diagnostics)
- Use QueryPad to View the Underlying Database Tables
- Scroll to Next Line or Next Page in QueryPad
- Select and Copy Information in QueryPad
- View your QueryPad Command History
- Disconnect QueryPad from a Database.