Neoview SQL Reference Manual (R2.5)

PARTITION_ACCESS ========================== SEQ_NO 2 ONLY CHILD 1
REQUESTS_IN .............. (not found)
ROWS_OUT ............... 100
EST_OPER_COST ............ 0.01
EST_TOTAL_COST ........... 0.01
DESCRIPTION
max_card_est ......... 100
fragment_id ............ 2
parent_frag ............ 0
fragment_type .......... dp2
buffer_size ....... 31,000
record_length ........ 306
space_usage ............ 5:32:100:144
bottom_node_map ........ (\THE0105:13)
FILE_SCAN ================================= SEQ_NO 1 NO CHILDREN
TABLE_NAME ............... NEO.USR.REGION
REQUESTS_IN .............. (not found)
ROWS_OUT ............... 100
EST_OPER_COST ............ 0.01
EST_TOTAL_COST ........... 0.01
DESCRIPTION
max_card_est ......... 100
fragment_id ............ 2
parent_frag ............ 0
fragment_type .......... dp2
scan_type .............. full scan of table NEO.USR.REGION
scan_direction ......... forward
lock_state ............. cursor
consistency_level ...... read_committed
columns_retrieved ...... 3
fast_scan .............. used
fast_replydata_move .... used
key_columns ............ R_KEY
begin_key .............. (R_KEY = <min>
end_key ................ (R_KEY = <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-4 (page 126)) and a node (or operator) listing (Section
(page 175)). 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;
128 SQL Statements