SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Metadata Tables
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
10-45
Default Attributes
OPTIMIZATION_LEVEL Controls increasing effort
in optimizing queries.
Query Optimization and
Performance on
page 10-66
OPTS_PUSH_DOWN_DAM
Controls whether NonStop
SQL/MX considers push-
down plans.
Query Optimization and
Performance on
page 10-66
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-66
PM_OFFLINE_ TRANSACTION_
GRANULARITY
Number of rows to be
copied in an offline
MODIFY transaction.
Partition Management
on page 10-63
PM_ONLINE_ TRANSACTION_
GRANULARITY
Number of rows to be
copied in an online
MODIFY transaction.
Partition Management
on page 10-63
POS_LOCATIONS
Controls location of
partitions to be
automatically created.
Partition Management
on page 10-63
POS_NUM_OF_PARTNS
Controls number of
partitions to be
automatically created.
Partition Management
on page 10-63
POS_RAISE_ERROR
Determines whether error
should be displayed.
Partition Management
on page 10-63
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-66
PRESERVE_MIN_SCALE
Allows you to preserve
minimum scale in a result
when the precision
exceeds 18.
Function Control on
page 10-52
PRIMARY_KEY_CONSTRAINT_
DROPPABLE_OPTION
Default for DROPPABLE
(ON) or NOT
DROPPABLE for
PRIMARY KEY constraint.
Constraint Droppable
Options on page 10-50
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-73
Attribute (page 6 of 9) Description Category