SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Metadata Tables
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
10-45
Default Attributes
OLT_QUERY_OPT Enables a fast path
evaluation method for
certain simple SQL
queries.
Query Optimization and
Performance on
page 10-66
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
Attribute (page 6 of 9) Description Category