SQL/MX 3.1 Installation and Management Guide (H06.23+, J06.12+)

Measuring Performance
HP NonStop SQL/MX Release 3.1 Installation and Management Guide—663852-001
14-3
SET STATISTICS and DISPLAY STATISTICS
Commands
has failed)
Primary Extent Size: 16 Pages
Secondary Extent Size: 64 Pages
Max Extents: 160
Extents Allocated: 1
EOF: 12288
Index Levels: 1
Record Expression Label Length: 13536
Security Label Length: 120
Key Encode Length: 2
Key Columns: 0 ASC
Partitioning Scheme: RP
Partition Array - 1 partition[s]
IndexMap Array - 2 index[es]
Index[0]: \DMR15.$SYSTEM.ZSDG5WVN.W3LB7T00
Index columns: 2 ASC , 1 ASC , 0 ASC
Index[1]: \DMR15.$SYSTEM.ZSDG5WVN.LVK37T00
Index columns: 3 ASC , 0 ASC
Trigger Status Array - 0 trigger[s]
Rcb version: 3000
Column attributes: maxDataLen: 53 (* marks special columns)
Attr[ 0/ 1] dataType: 131 offset: 4 len: 2 align: 2
Attr[ 1/ 2] dataType: 0 offset: 6 len: 15 align: 1
Attr[ 2/ 3] dataType: 0 offset: 21 len: 20 align: 1
Attr[ 3/ 4] dataType: 131 offset: 41 len: 2 align: 2
Attr[ 4/ 5] dataType: 131 offset: 45 len: 2 align: 2
nullOff: 43 nullBitIdx: -1
Attr[ 5/ -1] dataType: 133 offset: 49 len: 4 align: 4
nullOff: 47 nullBitIdx: -1
==============================================================
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 of the last executed DML statement.
SET STATISTICS and DISPLAY STATISTICS provide statistics for statements made
against either SQL/MP or SQL/MX objects.