SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Measuring Performance
HP NonStop SQL/MX Installation and Management Guide—523723-004
15-3
SET STATISTICS and DISPLAY STATISTICS
Commands
Max Extents: 160
Extents Allocated: 1
EOF: 12288
Index Levels: 2
Record Expression Label Length: 14280
Security Label Length: 120
Key Columns: 0 ASC
Partitioning Scheme: RP
Partition Array - 0 partition[s]
IndexMap Array - 2 index[es]
Index[0]: \KINGPIN.$TX0101.ZSDFM5XP.WR9ZNQ00
Index columns: 2 ASC , 1 ASC , 0 ASC
Index[1]: \KINGPIN.$TX0101.ZSDFM5XP.NPZDQQ00
Index columns: 3 ASC , 0 ASC
Trigger Status Array - 0 trigger[s]
==============================================================
For more information about SHOWLABEL, see Section 8, Querying SQL/MX Metadata
or the SQL/MX Reference Manual.
SET STATISTICS and DISPLAY STATISTICS Commands
MXCI provides the SET STATISTICS ON command, which displays statistics after
each statement executed in the session. You can also use the DISPLAY STATISTICS
command to get statistics on a single statement. The DISPLAY STATISTICS command
displays statistics for the immediately preceding statement.
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