SQL/MX 2.x Query Guide (G06.24+, H06.03+)

Operators and Operator Groups
HP NonStop SQL/MX Query Guide523728-003
7-22
INSERT_VSBB Operator
The INSERT operator has no child nodes. The description field for this operator
contains:
The example of the INSERT operator is based on:
INSERT INTO $big18a.sch.custss SELECT *
FROM $big18a.tpcd2x.customer
WHERE c_nationkey IN (1,3,7,8,10,15,18,20,22,44);
? XX
211862676932112060 4 INSERT
? ? \TESTSYS.$BIG18A.SCH.CUSTSS
1.0000000E+000 2.2347903E+000 2.2347903E+000
CPU_TIME: 0.031273 IO_TIME: 0.659791 MSG_TIME: 0 IDLETIME: 1.575
PROBES: 6213
new_rec_expr: ("\TESTSYS.$BIG18A".SCH.CUSTSS.C_CUSTKEY assign
indexcol(\TESTSYS.$BIG18A.TPCD2X.CUSTOMER.C_CUSTKEY)),
("\TESTSYS.$BIG18A".SCH.CUSTSS.C_NAME assign
indexcol(\TESTSYS.$BIG18A.TPCD2X.CUSTOMER.C_NAME)),
("\TESTSYS.$BIG18A".SCH.CUSTSS.C_ADDRESS assign
indexcol(\TESTSYS.$BIG18A.TPCD2X.CUSTOMER.C_ADDRESS)),
("\TESTSYS.$BIG18A".SCH.CUSTSS.C_NATIONKEY assign
indexcol(\TESTSYS.$BIG18A.TPCD2X.CUSTOMER.C_NATIONKEY)),
("\TESTSYS.$BIG18A".SCH.CUSTSS.C_PHONE assign
indexcol(\TESTSYS.$BIG18A.TPCD2X.CUSTOMER.C_PHONE)),
("\TESTSYS.$BIG18A".SCH.CUSTSS.C_ACCTBAL assign
indexcol(\TESTSYS.$BIG18A.TPCD2X.CUSTOMER.C_ACCTBAL)),
("\TESTSYS.$BIG18A".SCH.CUSTSS.C_MKTSEGMENT assign
indexcol(\TESTSYS.$BIG18A.TPCD2X.CUSTOMER.C_MKTSEGMENT)),
("\TESTSYS.$BIG18A".SCH.CUSTSS.C_COMMENT assign
indexcol(\TESTSYS.$BIG18A.TPCD2X.CUSTOMER.C_COMMENT))
part_key_predicates: ("\TESTSYS.$BIG18A".SCH.CUSTSS.C_CUSTKEY
assign indexcol(\TESTSYS.$BIG18A.TPCD2X.CUSTOMER.C_CUSTKEY))
INSERT_VSBB Operator
INSERT Group
The INSERT_VSBB operator describes that part of an execution plan that inserts
multiple rows into a table in DAM. The operator for an INSERT_VSBB operator is
always INSERT_VSBB.
Token Followed by ... Data Type
new_rec_expr Computation of the row to be
inserted
expr(text)
olt_optimization An indicator that shows
whether an optimization for
short, simple operations is
used. The value used is
returned if this optimization is
used.
text