SQL/MX 3.2.1 Query Guide (H06.26+, J06.15+)

Reviewing Query Execution Plans
HP NonStop SQL/MX Release 3.2.1 Query Guide—663851-003
4-8
Using the EXPLAIN Statement to Review the
Execution Plan
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 EXPLAIN statement 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 2.0646531-002
TP663851.fm Page 8 Wednesday, January 30, 2013 5:37 PM