SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—640322-001
10-41
Default Attributes
MDAM_SCAN_METHOD Enables or disables the
MultiDimensional Access
Method.
Query Optimization and
Performance on
page 10-63
MEMORY_USAGE_SAFETY_NET
Specifies the MXCMP
memory threshold in
megabyte.
Query Optimization and
Performance on
page 10-63
MIN_MAX_OPTIMIZATION
Enables or disables MIN-
MAX optimization.
Query Optimization and
Performance on
page 10-63
MP_SUBVOLUME
Default NonStop operating
system Guardian
subvolume.
Object Naming on
page 10-57
MP_SYSTEM
Default NonStop operating
system Guardian system
name.
Object Naming on
page 10-57
MP_VOLUME
Default NonStop operating
system Guardian volume.
Object Naming on
page 10-57
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-63
MULTIUNION
Controls the MultiUnion
operator.
Query Optimization and
Performance on
page 10-63
MXCMP_PLACES_LOCAL_
MODULES
Determines where
globally placed modules
are generated.
Module Management
on page 10-56
NAMETYPE
Default for the use of
three-part logical names
(ANSI) or four-part
Guardian names (NSK).
Object Naming on
page 10-57
NATIONAL_CHARSET
Default character set for
the use of NCHAR.
Character Set on
page 10-46
NOT_NULL_CONSTRAINT_
DROPPABLE_OPTION
Default for DROPPABLE
(ON) or NOT
DROPPABLE for NOT
NULL constraint.
Constraint Droppable
Options on page 10-47
NUMBER_OF_USERS
Number of users that can
run concurrent queries
that use large amounts of
memory.
Query Optimization and
Performance on
page 10-63
OLT_QUERY_OPT
Enables a fast path
evaluation method for
certain simple SQL
queries.
Query Optimization and
Performance on
page 10-63
Attribute (page 5 of 9) Description Category