SQL/MX 3.2 Query Guide (H06.25+, J06.14+)

SQL/MX Operators
HP NonStop SQL/MX Release 3.2 Query Guide—663851-002
7-32
INDEX_SCAN_UNIQUE Operator
The following is an example of the INDEX_SCAN_UNIQUE operator:
prepare TestQuery14 from
select * from supplier
where s_nationkey = 12 and
s_suppkey = 14;
DESCRIPTION
fragment_id ............ 2
parent_frag ............ 0
fragment_type .......... dp2
olt_optimization ....... not used
olt_opt_lean ........... not used
scan_type ..............
unique access of index
CAT.SCH.SX1(CAT.SCH.SUPPLIER)
key_type ............... simple
lock_mode .............. not specified, defaulted to lock
cursor
access_mode ............ not specified, defaulted to read
committed
columns_retrieved ...... 3
fast_replydata_move .... used
key_columns ............ CAT.SCH.SX1.S_NATIONKEY,
CAT.SCH.SX1.S_SUPPKEY
executor_predicates .... (CAT.SCH.SX1.S_SUPPKEY = %(14)) and
(CAT.SCH.SX1.S_SUPPKEY = %(14))
key .................... (CAT.SCH.SX1.S_NATIONKEY = %(12)),
(CAT.SCH.SX1.S_SUPPKEY = %(14))
access_mode The access specified: read uncommitted, skip
conflict, read committed, stable, serializable,
mx serializable, not specified (defaulted to
read committed), or unknown.
text
executor_predicates Any predicate expression that is not a key
predicate evaluated by the executor in DAM.
expr(text)
part_key_predicate Predicate expression specified on partitioning
key. It is displayed only if partitioning key
differs from clustering key.
expr(text)
columns_retrieved Estimated number of columns to be returned. integer
fast_replydata_move Indicates whether an optimization for returning
data from DAM is used. The value used is
returned if this optimization is used.
text
fast_scan Indicates whether an optimization for a simple
scan operation is used. The value used is
returned if this optimization is used.
text
olt_optimization Indicates whether an optimization for short,
simple operations is used. The value used is
returned if this optimization is used.
text
TP663851.fm Page 32 Thursday, August 2, 2012 4:47 PM