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

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—544517-008
2-153
Examples of EXPLAIN
FILE_SCAN_UNIQUE ========================== SEQ_NO 5 NO CHILDREN
TABLE_NAME ............... CAT.SCH.PART
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0.02
EST_TOTAL_COST ........... 0.02
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))
PARTITION_ACCESS ========================== SEQ_NO 4 ONLY CHILD 3
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0.01
EST_TOTAL_COST ........... 0.02
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.01
EST_TOTAL_COST ........... 0.02
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
DESCRIPTION
fragment_id ............ 2
parent_frag ............ 0
fragment_type .......... dp2