Neoview SQL Reference Manual (R2.4)

Table 2-5 Node Listing Information (continued)
DescriptionField
Estimated cost associated with execution of the current operator and all
children.
EST_TOTAL_COST
Additional information about the operation. For example, in the case of a
scan, the description field shows scan_type, scan_direction, lock_mode,
access_mode, columns_retrieved, optimization information, and so on. For
details about all operators and their description fields, see the Neoview Query
Guide.
DESCRIPTION
This example uses OPTIONS 'n':
>>explain options 'n' select * from region;
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... NOT NAMED
PLAN_ID .................. 212048684386644204
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0.01
STATEMENT ................ select * from region;
------------------------------------------------------------------ NODE LISTING
ROOT ====================================== SEQ_NO 4 ONLY CHILD 3
REQUESTS_IN .............. 1
ROWS_OUT ................. 5
EST_OPER_COST ............ 0.01
EST_TOTAL_COST ........... 0.01
DESCRIPTION
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
statement_index ........ 0
affinity_value 1,141,615,548
xn_access_mode ......... read_only
xn_autoabort_interval 0
plan_version ....... 2,020
SCHEMA ................. TPCH2X_CAT.TPCH2X_SCH
select_list ............ TPCH2X_CAT.TPCH2X_SCH.REGION.R_REGIONKEY,
TPCH2X_CAT.TPCH2X_SCH.REGION.R_NAME,
TPCH2X_CAT.TPCH2X_SCH.REGION.R_COMMENT
SPLIT_TOP ================================= SEQ_NO 3 ONLY CHILD 2
REQUESTS_IN .............. 1
ROWS_OUT ................. 5
EST_OPER_COST ............ 0
EST_TOTAL_COST ........... 0.01
DESCRIPTION
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
parent_processes ....... 1
child_processes ....... 64
parent_partitioning_fun grouped 1 to 64,PAPA with 64 PA(s),
exactly 1 partition
child_partitioning_func hash2 partitioned 64 ways on
(TPCH2X_CAT.TPCH2X_SCH.REGION.R_REGIONKEY)
bottom_node_map ........ (\SQA0101:0-15, \SQA0102:0-15, \SQA0103:0-15,
\SQA0104:0-15)
PARTITION_ACCESS ========================== SEQ_NO 2 ONLY CHILD 1
REQUESTS_IN .............. 1
ROWS_OUT ................. 5
EST_OPER_COST ............ 0
EST_TOTAL_COST ........... 0.01
DESCRIPTION
fragment_id ............ 2
parent_frag ............ 0
fragment_type .......... dp2
EXPLAIN Statement 123