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

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—544517-008
2-148
Examples of EXPLAIN
The following output is displayed:
•
Use OPTIONS 'e':
>>explain options 'e' xx;
The following output is displayed:
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- ---------------- ---------
7 . 8 root 1.00E+000
4 6 7 nested_join 1.00E+000
5 . 6 partition_access 1.00E+000
. . 5 file_scan_unique fr PART (s) 1.00E+000
3 . 4 partition_access 1.00E+000
2 . 3 shortcut_scalar_aggr 1.00E+000
1 . 2 firstn 1.00E+000
. . 1 index_scan PSX2 (s) 1.00E+002
--- SQL operation complete.
------------------------------------------------------------------ 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