Neoview Command Interface (NCI) Guide (R2.3)

EMPNUM LAST_NAME
------ --------------------
180 CONRAD
215 LANCASTER
216 JONES
225 HELMSTED
232 SPINNER
--- 5 row(s) selected.
SQL>
GET STATISTICS Command
The GET STATISTICS command returns formatted statistics for the last executed SQL statement.
Syntax
GET STATISTICS
Description of Returned Values:
Records Accessed
number of rows returned by disk process to EID (Executor In Disk process).
Records Used
number of rows returned by EID after selection.
Disk IOs
number of actual disk IOs done by disk process.
Message Count
number of messages sent/received between filesystem and disk process.
Message Bytes
number of message bytes sent/received between filesystem and disk process.
Lock Escl
number of lock escalations.
Lock Wait
number of lock waits.
Disk Process Busy Time
cpu time for disk process processes for the specified table.
Considerations
This command can be executed in SQL mode. The command requires an SQL terminator.
Examples
SQL>select * from job;
JOBCODE JOBDESC
------- ------------------
100 MANAGER
1234 ENGINEER
450 PROGRAMMER
900 SECRETARY
300 SALESREP
500 ACCOUNTANT
400 SYSTEM ANALYST
250 ASSEMBLER
420 ENGINEER
600 ADMINISTRATOR
200 PRODUCTION SUPV
--- 11 row(s) selected.
GET STATISTICS Command 101