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

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-37
Default Attributes
OPTS_PUSH_DOWN_DAM Controls whether NonStop
SQL/MX considers push-
down plans.
Query Optimization and
Performance on
page 10-54
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-54
PM_OFFLINE_ TRANSACTION_
GRANULARITY
Number of rows to be
copied in an offline
MODIFY transaction.
Partition Management
on page 10-51
PM_ONLINE_ TRANSACTION_
GRANULARITY
Number of rows to be
copied in an online
MODIFY transaction.
Partition Management
on page 10-51
POS_LOCATIONS
Controls location of
partitions to be
automatically created.
Partition Management
on page 10-51
POS_NUM_OF_PARTNS
Controls number of
partitions to be
automatically created.
Partition Management
on page 10-51
POS_RAISE_ERROR
Determines whether error
should be displayed.
Partition Management
on page 10-51
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-54
PRESERVE_MIN_SCALE
Allows you to preserve
minimum scale in a result
when the precision
exceeds 18.
Function Control on
page 10-41
PRIMARY_KEY_CONSTRAINT_
DROPPABLE_OPTION
Default for DROPPABLE
(ON) or NOT
DROPPABLE for
PRIMARY KEY constraint.
Constraint Droppable
Options on page 10-40
QUERY_CACHE
Controls the maximum
amount of memory that
the SQL/MX compiler is
allowed to use for holding
the cached plans of
previously compiled
queries.
Query Plan Caching on
page 10-59
QUERY_CACHE_MAX_VICTIMS
Limits the number of
entries that an unusually
large query plan is
allowed to displace from
the cache.
Query Plan Caching on
page 10-59
Attribute Description Category