SQL/MX 2.x Query Guide (G06.24+, H06.03+)

Reviewing Query Execution Plans
HP NonStop SQL/MX Query Guide—523728-003
4-8
Using DISPLAY_EXPLAIN to Review the Execution
Plan
PROBES: 1
statement_index: 0
statement: SELECT last_name, first_name, salary from
samdbcat.persnl.employee
where salary > 40000.00 and jobcode=450;
return select_list:
indexcol(SAMDBCAT.PERSNL.EMPLOYEE.LAST_NAME),
indexcol(SAMDBCAT.PERSNL.EMPLOYEE.FIRST_NAME),
indexcol(SAMDBCAT.PERSNL.EMPLOYEE.SALARY)
--- SQL operation complete.
This output for the FILE_SCAN operator is formatted for clarity of illustration:
Column Name DISPLAY_EXPLAIN Output
MODULE_NAME Null
STATEMENT_NAME __EXPL_NAME
PLAN_ID
211977924124011276
SEQ_NUM 1
OPERATOR FILE_SCAN
LEFT_CHILD_
SEQ_NUM
Null
RIGHT_CHILD_
SEQ_NUM
Null
TNAME SAMDBCAT.PERSNL.EMPLOYEE
CARDINALITY 2.0000000E+000
OPERATOR_COST 4.1293062E-002