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

Metadata Tables
HP NonStop SQL/MX Reference Manual—544517-008
10-37
Default Attributes
JOIN_ORDER_BY_USER Enables or disables join
order you specify in the
FROM clause of a query.
Query Optimization and
Performance on
page 10-57
MATERIALIZE
Default for whether inner
tables of join operations
with streams are
materialized.
Stream Access on
page 10-71
MAX_ESPS_PER_CPU_PER_OP
Maximum number of
ESPs the optimizer
considers starting for each
CPU for a given operator.
Query Optimization and
Performance on
page 10-57
MAX_ROWS_LOCKED_
FOR_STABLE_ACCESS
Maximum number of rows
that are locked in STABLE
ACCESS mode.
Locking on page 10-48
MDAM_SCAN_METHOD
Enables or disables the
MultiDimensional Access
Method.
Query Optimization and
Performance on
page 10-57
MEMORY_USAGE_SAFETY_NET
Specifies the MXCMP
memory threshold in
megabyte.
Query Optimization and
Performance on
page 10-57
MIN_MAX_OPTIMIZATION
Enables or disables MIN-
MAX optimization.
Query Optimization and
Performance on
page 10-57
MP_SUBVOLUME
Default NonStop operating
system Guardian
subvolume.
Object Naming on
page 10-51
MP_SYSTEM
Default NonStop operating
system Guardian system
name.
Object Naming on
page 10-51
MP_VOLUME
Default NonStop operating
system Guardian volume.
Object Naming on
page 10-51
MSCF_ET_REMOTE_MSG_
TRANSFER
Factors in the cost of
transferring messages to
and from a remote node.
Query Optimization and
Performance on
page 10-57
MULTIUNION
Controls the MultiUnion
operator.
Query Optimization and
Performance on
page 10-57
MXCMP_PLACES_LOCAL_
MODULES
Determines where
globally placed modules
are generated.
Module Management
on page 10-49
NAMETYPE
Default for the use of
three-part logical names
(ANSI) or four-part
Guardian names (NSK).
Object Naming on
page 10-51
Attribute (page 5 of 9) Description Category