SQL/MX 2.x Reference Manual (H06.04+)

MXCI Commands
HP NonStop SQL/MX Reference Manual—540440-003
4-23
Examples of DISPLAY STATISTICS
Examples of DISPLAY STATISTICS
•
Suppose that this was the last DML command issued:
DELETE FROM invent.partsupp
WHERE suppnum NOT IN
(SELECT suppnum FROM supplier
WHERE state='TEXAS');
--- 41 row(s) deleted.
You can display statistics for this statement by using the DISPLAY STATISTICS
command:
DISPLAY STATISTICS;
Start Time 2001/08/22 09:24:50.188
End Time 2001/08/22 09:24:51.966
Elapsed Time 00:00:01.777
Compile Time 00:00:00.633
Execution Time 00:00:01.145
Table Name Records Records Disk Message Message Lock
Accessed Used I/Os Count Bytes
SAMDBCAT.INVENT.PARTSUPP
49 49 0 2 9056 0
SAMDBCAT.INVENT.SUPPLIER
49 8 0 11 31304 0
SAMDBCAT.INVENT.PARTSUPP
41 41 0 6 17144 0
"\MYSYS.$SAMDB".INVENT.XSUPORD
41 41 2 9 23056 0
>>log;