Neoview SQL Reference Manual (R2.3)

buffer_size ....... 31,000
record_length ........ 184
space_usage ............ 8:32:100:144
bottom_partitioning_fun logphys partitioned(grouping, PAPA with 64 PA(s),
log=exactly 1 partition,
phys=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)
begin_part_no_expr ..... \:_sys_hostVarPAPartNo_1539575856
end_part_no_expr ....... \:_sys_hostVarPAPartNo_1539575856
FILE_SCAN ================================= SEQ_NO 1 NO CHILDREN
TABLE_NAME ............... TPCH2X_CAT.TPCH2X_SCH.REGION
REQUESTS_IN .............. 1
ROWS_OUT ................. 5
EST_OPER_COST ............ 0.01
EST_TOTAL_COST ........... 0.01
DESCRIPTION
fragment_id ............ 2
parent_frag ............ 0
fragment_type .......... dp2
scan_type .............. full scan of table TPCH2X_CAT.TPCH2X_SCH.REGION
scan_direction ......... forward
lock_mode .............. not specified, defaulted to lock cursor
access_mode ............ not specified, defaulted to read committed
columns_retrieved ...... 3
fast_scan .............. used
fast_replydata_move .... used
key_columns ............ R_REGIONKEY
begin_key .............. (R_REGIONKEY = <min>)
end_key ................ (R_REGIONKEY = <max>)
--- SQL operation complete.
Expert User [OPTIONS 'e'] Considerations
The expert user option provides all the plan data from the EXPLAIN plan in a readable and
understandable format. Like the normal user option, the expert user option provides a plan
summary at the top of the output (Table 2-3 (page 108)) and a node (or operator) listing (Section
(page 156)). The difference between the normal user and expert user output is in the detail costs.
The expert user option provides additional costing information and provides four digits of
precision for all floating-point numbers.
Detail cost fields break down the EST_TOTAL_COST field into four components:
Relative estimate of the processor cost needed to execute the instructions of this
operator and all children.
cpu_cost
Relative estimate of the I/O cost (depends on the number of seeks and amount of
data transferred) needed to perform the I/O for this operator and all children.
io_cost
Relative estimate of the messaging cost (depends on the number of local/remote
messages and amount of data sent) for this operator and all children.
msg_cost
Relative estimate of the idle cost (depends on the amount of expected wait for an
event) for this operator and all children. Events are opening a table, starting an ESP
process, and so on.
idle_cost
This example uses OPTIONS ‘e’:
>>explain options 'e' select * from region;
------------------------------------------------------------------ PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... NOT NAMED
PLAN_ID .................. 212048684386644204
ROWS_OUT ................. 5
EST_TOTAL_COST ........... 0.0092
STATEMENT ................ select * from region;
110 SQL Statements