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

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—544517-008
2-150
Examples of EXPLAIN
PARTITION_ACCESS ========================== SEQ_NO 4 ONLY CHILD 3
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0.0008
EST_TOTAL_COST ........... 0.0165
cpu_cost ............... 0.0008
io_cost ................ 0.0165
msg_cost ............... 0
idle_cost .............. 0
probes ................. 1
DESCRIPTION
fragment_id ............ 2
parent_frag ............ 0
fragment_type .......... dp2
buffer_size ....... 31,000
record_length .......... 8
space_usage ............ 12:8:8:32
eid_space_computation on
SHORTCUT_SCALAR_AGGR ====================== SEQ_NO 3 ONLY CHILD 2
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0.0001
EST_TOTAL_COST ........... 0.0165
cpu_cost ............... 0.0001
io_cost ................ 0.0165
msg_cost ............... 0
idle_cost .............. 0
probes ................. 1
DESCRIPTION
fragment_id ............ 2
parent_frag ............ 0
fragment_type .......... dp2
aggregates ............. max(CAT.SCH.PSX2.PS_PARTKEY)
FIRSTN ==================================== SEQ_NO 2 ONLY CHILD 1
REQUESTS_IN .............. (not found)
ROWS_OUT ................. 1
EST_OPER_COST ............ 0
EST_TOTAL_COST ........... 0
OPERATOR_COST .......... 0
ROLLUP_COST ............ 0
DESCRIPTION
fragment_id ............ 2
parent_frag ............ 0
fragment_type .......... dp2