SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
D-53
Example—DISPLAY STATISTICS
Records accessed does not indicate the specific number of physical disk reads
or writes because SQL uses disk caching to reduce the number of physical
read and write operations.
Records used is the number of rows that satisfy the query.

Number of disk reads

Message count
Message count is usually the number of blocks passed from the disk process
to the file system. Sometimes an additional message is needed to ensure that
the last row was processed.

Message bytes
Message bytes is the total amount of data transferred.

Lock
Lock contains information about lock escalation.
Example—DISPLAY STATISTICS
The last DML command is:
>> DELETE FROM I.P
+> WHERE SUPPNUM NOT IN (SELECT SUPPNUM FROM I.S
+> WHERE STATE = "TEXAS");
--- 41 row(s) deleted.
Although you did not display the statistics when executed, you can display them
using the DISPLAY STATISTICS command:
>> DISPLAY STATISTICS;
Estimated Cost 39
Start Time 94/06/01 09:07:16.678185
End Time 94/06/01 09:07:56.533061
Elapsed Time 00:00:39.854876
Master Executor Execution Time 00:00:00.359826
Records Records Disk Message Message Lock
Table Name Accessed Used Reads Count Bytes
\S.$V.I.S 48 42 4 84 6684
\S.$V.#2549 0 0 0 0 0
\S.$V.I.P 49 49 2 3 542
\S.$V.#2549 0 0 0 0 0