SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

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