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

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—544517-008
2-154
Examples of EXPLAIN
•
Use OPTIONS 'm':
>>explain options 'm' xx;
INDEX_SCAN ================================ SEQ_NO 1 NO CHILDREN
TABLE_NAME ............... CAT.SCH.PARTSUPP
REQUESTS_IN .............. 1
ROWS_OUT ............... 100
EST_OPER_COST ............ 0.02
EST_TOTAL_COST ........... 0.02
DESCRIPTION
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>)
--- SQL operation complete.