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

Metadata Tables
HP NonStop SQL/MX Reference Manual—544517-008
10-38
Default Attributes
NATIONAL_CHARSET Default character set for
the use of NCHAR.
National Character Set
on page 10-50
NOT_NULL_CONSTRAINT_
DROPPABLE_OPTION
Default for DROPPABLE
(ON) or NOT
DROPPABLE for NOT
NULL constraint.
Constraint Droppable
Options on page 10-42
NUMBER_OF_USERS
Number of users that can
run concurrent queries
that use large amounts of
memory.
Query Optimization and
Performance on
page 10-57
OLT_QUERY_OPT
Enables a fast path
evaluation method for
certain simple SQL
queries.
Query Optimization and
Performance on
page 10-57
OPTIMIZATION_LEVEL
Controls increasing effort
in optimizing queries.
Query Optimization and
Performance on
page 10-57
OPTS_PUSH_DOWN_DAM
Controls whether NonStop
SQL/MX considers push-
down plans.
Query Optimization and
Performance on
page 10-57
PARALLEL_NUM_ESPS
Maximum number of
parallel ESPs that work on
a particular type of
operator, like a join.
Query Optimization and
Performance on
page 10-57
PM_OFFLINE_ TRANSACTION_
GRANULARITY
Number of rows to be
copied in an offline
MODIFY transaction.
Partition Management
on page 10-54
PM_ONLINE_ TRANSACTION_
GRANULARITY
Number of rows to be
copied in an online
MODIFY transaction.
Partition Management
on page 10-54
POS_LOCATIONS
Controls location of
partitions to be
automatically created.
Partition Management
on page 10-54
POS_NUM_OF_PARTNS
Controls number of
partitions to be
automatically created.
Partition Management
on page 10-54
POS_RAISE_ERROR
Determines whether error
should be displayed.
Partition Management
on page 10-54
PREFERRED_PROBING_
ORDER_FOR_NESTED_JOIN
Controls whether rows of
the inner table must be
read in key order of the
access path.
Query Optimization and
Performance on
page 10-57
Attribute (page 6 of 9) Description Category