SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—544517-008
2-149
Examples of EXPLAIN
NESTED_JOIN =============================== SEQ_NO 7 CHILDREN 4, 6
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0.0001
EST_TOTAL_COST ........... 0.0372
cpu_cost ............... 0.0016
io_cost ................ 0.0372
msg_cost ............... 0
idle_cost .............. 0
probes ................. 1
DESCRIPTION
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
join_type .............. inner
join_method ............ nested
PARTITION_ACCESS ========================== SEQ_NO 6 ONLY CHILD 5
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0.0008
EST_TOTAL_COST ........... 0.0206
cpu_cost ............... 0.0008
io_cost ................ 0.0206
msg_cost ............... 0
idle_cost .............. 0
probes ................. 1
DESCRIPTION
fragment_id ............ 3
parent_frag ............ 0
fragment_type .......... dp2
buffer_size ....... 31,000
record_length ........ 177
space_usage ............ 13:8:8:36
eid_space_computation on
FILE_SCAN_UNIQUE ========================== SEQ_NO 5 NO CHILDREN
TABLE_NAME ............... CAT.SCH.PART
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0.0206
EST_TOTAL_COST ........... 0.0206
cpu_cost ............... 0.0001
io_cost ................ 0.0206
msg_cost ............... 0
idle_cost .............. 0
probes ................. 1
DESCRIPTION
fragment_id ............ 3
parent_frag ............ 0
fragment_type .......... dp2
olt_optimization ....... not used
olt_opt_lean ........... not used
scan_type .............. unique access of table CAT.SCH.PART
object_type ............ CAT.SCH.PART
key_type ............... simple
lock_mode .............. not specified, defaulted to lock cursor
access_mode ............ not specified, defaulted to read committed
columns_retrieved ...... 9
fast_replydata_move .... used
key_columns ............ P_PARTKEY
key .................... (P_PARTKEY = max(CAT.SCH.PSX2.PS_PARTKEY))