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

Reviewing Query Execution Plans
HP NonStop SQL/MX Query Guide—523728-003
4-7
Using DISPLAY_EXPLAIN to Review the Execution
Plan
PLAN_ID
SEQ_NUM
OPERATOR
LEFT_CHILD_SEQ_NUM
RIGHT_CHILD_SEQ_NUM
TNAME
CARDINALITY OPERATOR_COST TOTAL_COST DETAIL_COST
DESCRIPTION
?
EXPL_NAME__
211977924124011276 1 FILE_SCAN ? ?
SAMDBCAT.PERSNL.EMPLOYEE
2.0000000E+000 4.1293062E-002 4.1293062E-002
CPU_TIME: 0.000433
IO_TIME: 0.041293
MSG_TIME: 0
IDLETIME: 0
PROBES: 1
scan_type: file_scan SAMDBCAT.PERSNL.EMPLOYEE
scan_direction: forward
key_type: simple
lock_mode: not specified
access_mode: not specified
columns_retrieved: 6
fast_scan: used
fast_replydata_move: used
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)
end_key: (indexcol(SAMDBCAT.PERSNL.EMPLOYEE.EMPNUM) = 9999)
?
EXPL_NAME__
211977924124011276 2 PARTITION_ACCESS 1
?
2.0000000E+000 2.0422223E-003 4.1293062E-002
CPU_TIME: 0.002476
IO_TIME: 0.041293
MSG_TIME: 0
IDLETIME: 0
PROBES: 1
buffer_size: 31000
record_length: 44
?
EXPL_NAME__
211977924124011276 3 ROOT 2
?
2.0000000E+000 9.8000802E-002 1.3929305E-001
CPU_TIME: 0.002476
IO_TIME: 0.041293
MSG_TIME: 0
IDLETIME: 0.098