SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—544517-008
2-156
Examples of EXPLAIN
? X X
212122794829778687 4 PARTITION_ACCESS 3
?
1.0000000E+000 7.5787946E-004 1.6517225E-002 CPU_TIME: 0.000805815
IO_TIME: 0.0165172 MSG_TIME: 0 IDLETIME: 0 PROBES: 1
fragment_id: 2 parent_frag: 0 fragment_type: dp2 buffer_size: 31000
record_length: 8 space_usage: 12:8:8:32 eid_space_computation: on
? X X
212122794829778687 5 FILE_SCAN_UNIQUE ?
? CAT.SCH.PART
1.0000000E+000 2.0646531E-002 2.0646531E-002 CPU_TIME: 3.18424e-005
IO_TIME: 0.0206465 MSG_TIME: 0 IDLETIME: 0 PROBES: 1
fragment_id: 3 parent_frag: 0 fragment_type: dp2 olt_optimization: not
used olt_opt_lean: not used scan_type: unique access of table CAT.SCH.PART
object_type: CAT.SCH.PART key_type: simple lock_mode: not specified,
defaulted to lock cursor access_mode: not specified, defaulted to read
committed columns_retrieved: 9 fast_replydata_move: used key_columns:
P_PARTKEY key: (P_PARTKEY = max(CAT.SCH.PSX2.PS_PARTKEY))
? X X
212122794829778687 6 PARTITION_ACCESS 5
?
1.0000000E+000 7.6004536E-004 2.0646531E-002 CPU_TIME: 0.000791888
IO_TIME: 0.0206465 MSG_TIME: 0 IDLETIME: 0 PROBES: 1
fragment_id: 3 parent_frag: 0 fragment_type: dp2 buffer_size: 31000
record_length: 177 space_usage: 13:8:8:36 eid_space_computation: on
? X X
212122794829778687 7 NESTED_JOIN 4
6
1.0000000E+000 4.1742293E-007 3.7163756E-002 CPU_TIME: 0.00159812
IO_TIME: 0.0371638 MSG_TIME: 0 IDLETIME: 0 PROBES: 1
fragment_id: 0 parent_frag: (none) fragment_type: master join_type: inner
join_method: nested
? X X
212122794829778687 8 ROOT 7
?
1.0000000E+000 1.9600035E-001 2.3316375E-001 CPU_TIME: 0.00159847
IO_TIME: 0.0371638 MSG_TIME: 0 IDLETIME: 0.196 PROBES: 1
fragment_id: 0 parent_frag: (none) fragment_type: master statement_index:
0 statement: select * from part where p_partkey = (select max(ps_partkey)
from partsupp); xn_access_mode: read_only plan_version: 2400 SCHEMA:
CAT.SCH select_list: CAT.SCH.PART.P_PARTKEY, CAT.SCH.PART.P_NAME,
CAT.SCH.PART.P_MFGR, CAT.SCH.PART.P_BRAND, CAT.SCH.PART.P_TYPE,
CAT.SCH.PART.P_SIZE, CAT.SCH.PART.P_CONTAINER, CAT.SCH.PART.P_RETAILPRICE,
CAT.SCH.PART.P_COMMENT
--- SQL operation complete.