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

Operators and Operator Groups
HP NonStop SQL/MX Query Guide—523728-003
7-38
PARTITION_ACCESS Operator
INTEGER,
"staff_city" ROWSET 5 ANSIVARCHAR(15))
SELECT * into
:"staff_num",:"staff_name",:"staff_grade",:"staff_city"
FROM RSSTAFF;
Command in MXCI:
>>SELECT OPERATOR, CARDINALITY, OPERATOR_COST, DESCRIPTION FROM
TABLE(EXPLAIN(('CAT.SCH.TESTE051M','SQLMX_DEFAULT_STATEMENT_3')));
OPERATOR CARDINALITY OPERATOR_COST DESCRIPTION
FILE_SCAN 1.9067585E+002 2.2145127E-002 key_columns:
indexcol(CAT.SCH.RSSTAFF.SYSKEY)
begin_key: (indexcol(CAT.SCH.RSSTAFF.SYSKEY) = -9223372036854775808)
end_key: (indexcol(CAT.SCH.RSSTAFF.SYSKEY) = 9223372036854775807)
scan_type: file_scan CAT.SCH.RSSTAFF
scan_direction: forward
key_type: simple
lock_mode: not specified
access_mode: not specified
columns_retrieved: 5
fast_replydata_move: used
PARTITION_ACCESS 1.9067585E+002 2.5107495E-003
buffer_size: 31000 record_length: 44
PACK 3.8135169E+001 0.0000000E+000
pack_expr: (cast(indexcol(CAT.SCH.RSSTAFF.EMPNUM)) RowsetArrayInto 5 ),
(cast(indexcol(CAT.SCH.RSSTAFF.EMPNAME)) RowsetArrayInto 5 ),
(cast(indexcol(CAT.SCH.RSSTAFF.GRADE)) RowsetArrayInto 5 ),
(cast(cast(indexcol(CAT.SCH.RSSTAFF.CITY))) RowsetArrayInto 5 )
ROOT 3.8135169E+001 9.8091781E-002
select_list: (cast(indexcol(CAT.SCH.RSSTAFF.EMPNUM)) RowsetArrayInto 5 ),
(cast(indexcol(CAT.SCH.RSSTAFF.EMPNAME)) RowsetArrayInto 5 ),
(cast(indexcol(CAT.SCH.RSSTAFF.GRADE)) RowsetArrayInto 5 ),
(cast(cast(indexcol(CAT.SCH.RSSTAFF.CITY))) RowsetArrayInto 5 )
statement_index: 1 statement: PROCEDURE SQLMX_DEFAULT_STATEMENT_3
("staff_num" ROWSET 5 CHARACTER(3),"staff_name" ROWSET 5
CHARACTER(20),"staff_grade" ROWSET 5 INTEGER,"staff_city" ROWSET 5
ANSIVARCHAR(15)) SELECT * into
:"staff_num",:"staff_name",:"staff_grade",:"staff_city"
FROM RSSTAFF;
--- 4 row(s) selected.
PARTITION_ACCESS Operator
Exchange Group
Use the PARTITION_ACCESS operator to describe a portion of an execution plan for
a file system interface in which requests are made to DAM. The DAM process runs in
parallel to the PARTITION_ACCESS (no waited interface). For more information about
exchange operators, see Section 8, Parallelism.