SQL/MX 2.x Reference Manual (H06.04+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-36
Default Attributes
MAX_ROWS_LOCKED_
FOR_STABLE_ACCESS
Maximum number of rows
that are locked in STABLE
ACCESS mode.
Locking on page 10-46
MDAM_SCAN_METHOD
Enables or disables the
MultiDimensional Access
Method.
Query Optimization and
Performance on
page 10-54
MIN_MAX_OPTIMIZATION
Enables or disables MIN-
MAX optimization.
Query Optimization and
Performance on
page 10-54
MP_SUBVOLUME
Default NonStop operating
system Guardian
subvolume.
Object Naming on
page 10-48
MP_SYSTEM
Default NonStop operating
system Guardian system
name.
Object Naming on
page 10-48
MP_VOLUME
Default NonStop operating
system Guardian volume.
Object Naming on
page 10-48
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-54
MXCMP_PLACES_LOCAL_
MODULES
Determines where
globally placed modules
are generated.
Module Management
on page 10-47
NAMETYPE
Default for the use of
three-part logical names
(ANSI) or four-part
Guardian names (NSK).
Object Naming on
page 10-48
NATIONAL_CHARSET
Default character set for
the use of NCHAR.
National Character Set
on page 10-47
NOT_NULL_CONSTRAINT_
DROPPABLE_OPTION
Default for DROPPABLE
(ON) or NOT
DROPPABLE for NOT
NULL constraint.
Constraint Droppable
Options on page 10-40
NUMBER_OF_USERS
Number of users that can
run concurrent queries
that use large amounts of
memory.
Query Optimization and
Performance on
page 10-54
OLT_QUERY_OPT
Enables a fast path
evaluation method for
certain simple SQL
queries.
Query Optimization and
Performance on
page 10-54
OPTIMIZATION_LEVEL
Controls increasing effort
in optimizing queries.
Query Optimization and
Performance on
page 10-54
Attribute Description Category