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

MXCI Commands
HP NonStop SQL/MX Reference Manual—540440-003
4-15
Examples of DISPLAY_EXPLAIN
buffer_size: 31000 record_length: 48
?
EXPL_NAME__
211864141076058828 3 ROOT
2 ?
2.4783301E+000 9.8001182E-002 1.1864653E-001
CPU_TIME: 0.002373 IO_TIME: 0.020647 MSG_TIME: 0
IDLETIME: 0.098 PROBES: 1
select_list: indexcol(\SAMDBCAT.PERSNL.EMPLOYEE.EMPNUM),
indexcol(\SAMDBCAT.PERSNL.EMPLOYEE.FIRST_NAME),
indexcol(\SAMDBCAT.PERSNL.EMPLOYEE.LAST_NAME),
indexcol(\SAMDBCAT.PERSNL.EMPLOYEE.DEPTNUM), 450,
indexcol(\SAMDBCAT.PERSNL.EMPLOYEE.SALARY)
statement_index: 0
statement: SELECT * FROM persnl.employee WHERE salary >
40000.00 AND jobcode=450;
--- SQL operation complete.
•
This example shows the first part of the result table of the EXPLAIN function (with
SEQ_NUM equal to 1). When you run the DISPLAY_EXPLAIN command, you
must page down to see the remaining sequence numbers for the specified
statement. In this example, the columns for SEQ_NUM equal to 1 are arranged
vertically for readability.
>>DISPLAY_EXPLAIN
+> SELECT * FROM persnl.employee
+> WHERE salary > 40000.00 AND jobcode =450;
--- SQL command prepared.
MODULE_NAME ?
STATEMENT_NAME EXPL_NAME
PLAN_ID 211864141076058828
SEQ_NUM 1
OPERATOR FILE_SCAN
LEFT_CHILD_SEQ_NUM ?
RIGHT_CHILD_SEQ_NUM ?
TNAME SAMDBCAT.PERSNL.EMPLOYEE
CARDINALITY 2.4783301E+000
OPERATOR_COST 2.0646531E-002
TOTAL_COST 2.0646531E-002
DETAIL_COST CPU_TIME: 0.000327 IO_TIME: 0.020647 MSG_TIME:
0 IDLETIME: 0 PROBES: 1
DESCRIPTION
key_columns: indexcol(\SAMDBCAT.PERSNL.EMPLOYEE.EMPNUM)
executor_predicates:
(indexcol(\SAMDBCAT.PERSNL.EMPLOYEE.SALARY) > 40000.00) and
(indexcol(\SAMDBCAT.PERSNL.EMPLOYEE.JOBCODE) = 450)
begin_key: (indexcol(\SAMDBCAT.PERSNL.EMPLOYEE.EMPNUM) = 0)