SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—544517-008
10-34
Default Attributes
CACHE_HISTOGRAMS Controls whether the
optimizer caches
histograms.
Histograms on
page 10-43
CACHE_HISTOGRAMS_
REFRESH_INTERVAL
Controls interval at which
histograms are refreshed.
Histograms on
page 10-43
CATALOG
Default ANSI catalog
name.
Object Naming on
page 10-51
CHECK_CONSTRAINT_PRUNING
Controls the check
constraints pruning
optimization.
Query Optimization and
Performance on
page 10-57
CROSS_PRODUCT_CONTROL
Determines whether plans
are eliminated that contain
unnecessary
cross-products.
Query Optimization and
Performance on
page 10-57
DATA_FLOW_OPTIMIZATION
Controls whether query
plans are considered that
have high data flow rates.
Query Optimization and
Performance on
page 10-57
DDL_DEFAULT_ LOCATIONS
Specifies the physical
location of the primary
range partition to be
created by CREATE
statements that do not
specify a LOCATION
clause.
Partition Management
on page 10-54
DEF_MAX_HISTORY_ ROWS
Default for number of
rows the SEQUENCE BY
operator keeps in its
history buffer.
Sequence Functions on
page 10-68
DOOM_USERTRANSACTION
Controls whether NonStop
SQL/MX dooms a
transaction when it
encounters an
unrecoverable error.
Statement Atomicity on
page 10-69
DP2_CACHE_4096_BLOCKS
Specifies blocks allocated
for disk cache.
Query Optimization and
Performance on
page 10-57
DYNAMIC_HISTOGRAM_
COMPRESSION
Reduces the number of
histogram intervals for
histograms of base table
columns when those
histograms are read from
disk.
Histograms on
page 10-43
Attribute (page 2 of 9) Description Category