SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
2-224
Examples of EXPLAIN
•
This is an example of insert…select with an IDENTITY column:
create table tab1(a largeint generated always as identity, b
int);
--- SQL operation complete.
prepare xx from insert into tab1 values(DEFAULT, 1);
--- SQL command prepared.
explain options 'f' xx;
LC RC OP OPERATOR OPT DESCRIPTION CARD
---- ---- ---- -------------------- -------- --------------- ---------
9 . 10 root r 1.00E+000
6 8 9 tuple_flow 1.00E+000
7 . 8 partition_access 1.00E+000
. . 7 insert TAB1 1.00E+000
1 5 6 nextvaluefor 1.00E+000
4 . 5 esp_access 1.00E+000
3 . 4 sequencegenerator 1.00E+000
2 . 3 partition_access 1.00E+002
. . 2 subset_update "@@INTERNAL_SG_19505 1.00E+002
. . 1 values 1.00E+000
--- SQL operation complete.
>>