SQL/MX 3.x Installation and Management Guide (H06.22+, J06.11+)

Measuring Performance
HP NonStop SQL/MX Installation and Management Guide—640325-001
14-4
SET STATISTICS and DISPLAY STATISTICS
Commands
SET STATISTICS and DISPLAY STATISTICS provide statistics for statements made
against either SQL/MP or SQL/MX objects.
To obtain statistics, use either of these commands in your MXCI session:
Suppose that this is the last DML command issued:
SELECT * FROM SAMDBCAT.SALES.EMPLOYEE:
Command Type this command. . .
SET STATISTICS ON; Before a statement
DISPLAY STATISTICS; After a statement