SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
2-229
MXCI Examples of INSERT
test1 where col1 <= 3;
explain s1;
-------------------------------------------------------------
----- PLAN SUMMARY
MODULE_NAME .............. DYNAMICALLY COMPILED
STATEMENT_NAME ........... S1
PLAN_ID .................. 212204691857830064
ROWS_OUT ................ 33
EST_TOTAL_COST ........... 0.03
STATEMENT ................ insert into test1
select col1 + 10, col2
from test1
where col1 <= 3;
-------------------------------------------------------------
----- NODE LISTING
ROOT ====================================== SEQ_NO 6
ONLY CHILD 5
REQUESTS_IN .............. 1
ROWS_OUT ................ 33
EST_OPER_COST ............ 0
EST_TOTAL_COST ........... 0.03
DESCRIPTION
max_card_est .......... 33
fragment_id ............ 0
parent_frag ............ (none)
fragment_type .......... master
statement_index ........ 0
olt_optimization ....... not used
affinity_value 304,391,840
upd_action_on_error .... savepoint
xn_autoabort_interval -1
plan_version ....... 3,200
self_referencing_update dp2_locks
MXCI_PROCESS ........... ON
SHOWCONTROL_UNEXTERNALI OFF