SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—523725-004
10-35
Default Attributes
MDAM_SCAN_METHOD Enables or disables the
MultiDimensional Access
Method.
Query Optimization and
Performance on
page 10-53
MIN_MAX_OPTIMIZATION
Enables or disables MIN-
MAX optimization.
Query Optimization and
Performance on
page 10-53
MP_SUBVOLUME
Default NonStop operating
system Guardian
subvolume.
Object Naming on
page 10-47
MP_SYSTEM
Default NonStop operating
system Guardian system
name.
Object Naming on
page 10-47
MP_VOLUME
Default NonStop operating
system Guardian volume.
Object Naming on
page 10-47
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-53
MXCMP_PLACES_LOCAL_
MODULES
Determines where
globally placed modules
are generated.
Module Management
on page 10-46
NAMETYPE
Default for the use of
three-part logical names
(ANSI) or four-part
Guardian names (NSK).
Object Naming on
page 10-47
NATIONAL_CHARSET
Default character set for
the use of NCHAR.
National 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-39
NUMBER_OF_USERS
Number of users that can
run concurrent queries
that use large amounts of
memory.
Query Optimization and
Performance on
page 10-53
OLT_QUERY_OPT
Enables a fast path
evaluation method for
certain simple SQL
queries.
Query Optimization and
Performance on
page 10-53
OPTIMIZATION_LEVEL
Controls increasing effort
in optimizing queries.
Query Optimization and
Performance on
page 10-53
OPTS_PUSH_DOWN_DAM
Controls whether NonStop
SQL/MX considers push-
down plans.
Query Optimization and
Performance on
page 10-53
Attribute Description Category