SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
D-52
DISPLAY STATISTICS Command
Some sample lines of this report are:
FRESNO STATE BANK
2300 BROWN BLVD
FRESNO, CALIFORNIA 93921
DISPLAY STATISTICS Command
DISPLAY STATISTICS is an SQLCI command that displays statistics about the last
DML or PREPARE the statement you executed.
Considerations—DISPLAY STATISTICS

You can use DISPLAY STATISTICS at any time to see the statistics of the most
recent DML or PREPARE statement but if you set the STATISTICS option to ON,
SQLCI displays statistics automatically after each DML, DCL, DDL, or PREPARE
statement executes. For information, see SET SESSION Command on page S-39.

SQLCI displays these statistics:

Estimated cost
Estimated cost is a relative measure of cost derived using the same cost
functions that the SQL compiler uses to choose a query execution plan. The
estimate includes processor, disk I/O, and message costs. Higher numbers
tend to indicate that SQL expects to process larger amounts of data. Large
numbers are not typically associated with fast on-line response times. Lower
numbers imply more efficient execution, but can be affected by missing or
inaccurate statistics or by skewed data distribution.
For information about cost, see the SQL/MP Query Guide.

Start Time, End Time, Elapsed Time, and Master Executor Execution Time
Master Executor Execution time is the amount of processor time used by the
SQL executor. Elapsed time includes the execution time, I/O time, and the time
used to display the result.

Number of records accessed and number of records used
Records accessed is the number of rows read (including rows that do not
satisfy the selection criteria). Rows are counted for each table, underlying table
of a protection view, and temporary table. If you join a table to itself, separate
statistics are reported for each instance of the table. The number of rows
accessed in an index is not reported.
DISPLAY STATISTICS ;