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

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—544517-008
2-155
Examples of EXPLAIN
The following output is displayed:
MODULE_NAME
STATEMENT_NAME PLAN_ID
SEQ_NUM OPERATOR LEFT_CHILD_SEQ_NUM
RIGHT_CHILD_SEQ_NUM TNAME
CARDINALITY OPERATOR_COST TOTAL_COST DETAIL_COST
DESCRIPTION
------------------------------------------------------------ ------------
------------------------------------------------ -------------------- --
--------- ------------------------------ ------------------ -----------
-------- ------------------------------------------------------------ --
------------- --------------- --------------- -------------------------
--------------------------------------------------------------------------
--------------------------------------------------------------------------
--------------------------- -------------------
? X X
212122794829778687 1 INDEX_SCAN ?
? CAT.SCH.PARTSUPP
1.0000000E+002 2.0646531E-002 2.0646531E-002 CPU_TIME: 5.56943e-005
IO_TIME: 0.0206465 MSG_TIME: 0 IDLETIME: 0 PROBES: 1
fragment_id: 2 parent_frag: 0 fragment_type: dp2 olt_optimization: not
used olt_opt_lean: not used scan_type: full scan of index
CAT.SCH.PSX2(CAT.SCH.PARTSUPP) scan_direction: reverse object_type:
CAT.SCH.PARTSUPP key_type: simple lock_mode: not specified, defaulted to
lock cursor access_mode: not specified, defaulted to read committed
columns_retrieved: 6 key_columns: CAT.SCH.PSX2.PS_PARTKEY,
CAT.SCH.PSX2.PS_SUPPKEY, CAT.SCH.PSX2.PS_SUPPLYCOST,
CAT.SCH.PSX2.PS_AVAILQTY, CAT.SCH.PSX2.PS_PARTKEY, CAT.SCH.PSX2.PS_SUPPKEY
begin_key: (CAT.SCH.PSX2.PS_PARTKEY = <max>), (CAT.SCH.PSX2.PS_SUPPKEY =
<max>), (CAT.SCH.PSX2.PS_SUPPLYCOST = <max>), (CAT.SCH.PSX2.PS_AVAILQTY =
<max>), (CAT.SCH.PSX2.PS_PARTKEY = <max>), (CAT.SCH.PSX2.PS_SUPPKEY =
<max>) end_key: (CAT.SCH.PSX2.PS_PARTKEY = <min>),
(CAT.SCH.PSX2.PS_SUPPKEY = <min>), (CAT.SCH.PSX2.PS_SUPPLYCOST = <min>),
(CAT.SCH.PSX2.PS_AVAILQTY = <min>), (CAT.SCH.PSX2.PS_PARTKEY = <min>),
(CAT.SCH.PSX2.PS_SUPPKEY = <min>)
? X X
212122794829778687 2 FIRSTN 1
?
1.0000000E+000 0.0000000E+000 0.0000000E+000 OPERATOR_COST: 0
ROLLUP_COST: 0
fragment_id: 2 parent_frag: 0 fragment_type: dp2
? X X
212122794829778687 3 SHORTCUT_SCALAR_AGGR 2
?
1.0000000E+000 3.3796350E-006 1.6517225E-002 CPU_TIME: 4.79351e-005
IO_TIME: 0.0165172 MSG_TIME: 0 IDLETIME: 0 PROBES: 1
fragment_id: 2 parent_frag: 0 fragment_type: dp2 aggregates:
max(CAT.SCH.PSX2.PS_PARTKEY)