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

Metadata Tables
HP NonStop SQL/MX Reference Manual—523725-004
10-36
Default Attributes
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-53
PM_OFFLINE_ TRANSACTION_
GRANULARITY
Number of rows to be
copied in an offline
MODIFY transaction.
Partition Management
on page 10-50
PM_ONLINE_ TRANSACTION_
GRANULARITY
Number of rows to be
copied in an online
MODIFY transaction.
Partition Management
on page 10-50
POS_LOCATIONS
Controls location of
partitions to be
automatically created.
Partition Management
on page 10-50
POS_NUM_OF_PARTNS
Controls number of
partitions to be
automatically created.
Partition Management
on page 10-50
POS_RAISE_ERROR
Determines whether error
should be displayed.
Partition Management
on page 10-50
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-53
PRESERVE_MIN_SCALE
Allows you to preserve
minimum scale in a result
when the precision
exceeds 18.
Function Control on
page 10-40
PRIMARY_KEY_CONSTRAINT_
DROPPABLE_OPTION
Default for DROPPABLE
(ON) or NOT
DROPPABLE for
PRIMARY KEY constraint.
Constraint Droppable
Options on page 10-39
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-58
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-58
Attribute Description Category