SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—640322-001
2-150
Examples of EXPLAIN
The following output is displayed:
------------------------------------------------------------------ PLAN
SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... XX
PLAN_ID .................. 212122794829778687
ROWS_OUT ................. 1
EST_TOTAL_COST ........... 0.2332
STATEMENT ................ select *
from part
where p_partkey = (select max(ps_partkey) from
partsupp);
------------------------------------------------------------------ NODE
LISTING
ROOT ====================================== SEQ_NO 8 ONLY CHILD 7
REQUESTS_IN .............. 1
ROWS_OUT ................. 1
EST_OPER_COST ............ 0.196
EST_TOTAL_COST ........... 0.2332
cpu_cost ............... 0.0016
io_cost ................ 0.0372
msg_cost ............... 0
idle_cost .............. 0.196
probes ................. 1
DESCRIPTION
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
statement_index ........ 0
xn_access_mode ......... read_only
plan_version ....... 2,400
SCHEMA ................. CAT.SCH
select_list ............ CAT.SCH.PART.P_PARTKEY, CAT.SCH.PART.P_NAME,
CAT.SCH.PART.P_MFGR, CAT.SCH.PART.P_BRAND,
CAT.SCH.PART.P_TYPE, CAT.SCH.PART.P_SIZE,
CAT.SCH.PART.P_CONTAINER,
CAT.SCH.PART.P_RETAILPRICE,
CAT.SCH.PART.P_COMMENT