beautypg.com

Query workbench settings, Query list box, Query workbench settings query list box – HP Neoview Release 2.5 Software User Manual

Page 92

background image

All boxes in the Query Workbench can be moved by selecting the box to move it, or resize by
clicking the box in the upper right corner of the box.

Query Workbench Settings

The Tools>Options>Query Workbench Settings allow you to control the Query Workbench
behavior. The available options include:

Description

Option

Indicates the maximum number of rows to fetch for an execute
operation.

Max Rows

Adds a new query to the SQL Text box in the Query Workbench if
an existing query is changed and then executed or explained.

Auto Version Queries

Enables or disables [Execute] in the Query Workbench.

Enable Query Execution

Enables or disables colored process boundaries for explain plans in
the Query Workbench Query Details. When not checked, removes
color from process boundaries.

Color Process Boundaries

Enables or disables the ability to sort explain plan grid rows by
operator level. When not checked, sorts according to grid values.

Sort Plan Grid by Levels

Query List Box

The Query List box helps you manage a set of queries. The combined items in the Query List
box are called a query set. The Query List box contains the queries you selected in the Triage
Space and loaded into the Query Workbench or queries that you loaded from any saved
workbench data files. Individual queries can be selected using the associated check box for each
query item and multiple query set (batch) operations can be performed on the selected query
set. You can perform several actions based on these queries. Note that checked and selected

92

Use the Query Workbench