HP Neoview Release 2.4 Software - Manual (Page 78)

Rename the Query
You can rename the selected query in the Name box above the query field.
Statistics
The Statistics frame contains query statistics and details propagated from the query in the Triage
Space. This frame is purely informational and has no interactive functionality. Statistics are
shown only for queries that are loaded from the Triage Space. If a query is changed in the SQL
Text frame and executed again, the statistics will be invalid. The fields in the Statistics frame
include:
Description Field
Data source though which the data was collected. Data Source
Client name that ran the query. Client ID
SQL error code. 0 means no error. Error Code
Start time for the query. Start Time
End time for the query. End Time
Total time it took for the query to run. Elapsed Time
Time it took for the Neoview platform to execute the query. Execution Time
Estimated cost of the query. Estimated Cost
Number of rows accessed by the query. Rows Accessed
Number of rows retrieved. Rows Retrieved
Total number of rows inserted, updated, or deleted in all tables
accessed by the query. Rows IUD
Number of disk reads performed by the Data Access Manager to
access all the tables associated with this query. Disk Reads
Number of messages sent to the Data Access Manager to access the
table. Messages to Disk
Number of bytes exchanged between the file system and the Data
Access Manager in accessing all tables associated with this query. Msg Bytes to Disk
Number of times row locks escalated to file lock on any tables
associated with this query during the execution of the query. Lock Escalations
Number of times access to tables associated with this query was
delayed due to conflicting lock mode. Lock Waits
Query Workbench Query Details
The Query Details frame contains the Explain Plan and Execute Output tabs.
Explain Plan
The Explain Plan area shows the query plan output in a tabular tree format. The Explain Plan
area is divided into three sections. The left section shows the query plan in tree format. The
middle section shows details about the plan in grid form. See
Analyze the Explain Plan Through
the Grid . The right section shows the Plan Summary and Operator Details , which includes the
Cost Details and Description columns of the Explain output. Tool tips provide information
throughout the query plan output. Additionally, you can get in-depth information about each
operator in the query plan by right clicking on the operator and choosing “Help.” This points
78 Use the Query Workbench