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-41
Default Attributes
DATA_FLOW_OPTIMIZATION Controls whether query
plans are considered that
have high data flow rates.
Query Optimization and
Performance on
page 10-66
DDL_DEFAULT_ LOCATIONS
Specifies the physical
location of the primary
partition to be created by
CREATE statements that
do not specify a
LOCATION clause.
Partition Management
on page 10-63
DDL_VIEW_SIMILARITY_CHECK
Specifies whether views
by default are created with
Similarity Check enabled
or disabled.
Query Optimization and
Performance on
page 10-66
DEF_MAX_HISTORY_ ROWS
Default for number of
rows the SEQUENCE BY
operator keeps in its
history buffer.
Sequence Functions on
page 10-77
DEFAULT_BLOCKSIZE
on
page 10-81
enables you to change the
default behavior when
database objects are
created that do not specify
a BLOCKSIZE.
Table Management on
page 10-81
DOOM_USERTRANSACTION
Controls whether NonStop
SQL/MX dooms a
transaction when it
encounters an
unrecoverable error.
Statement Atomicity on
page 10-78
DP2_CACHE_4096_BLOCKS
Specifies blocks allocated
for disk cache.
Query Optimization and
Performance on
page 10-66
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-52
FFDC_DIALOUTS_FOR_MXCMP
Controls whether FFDC
dial-outs should occur
when the compiler
terminates abnormally or
detects an internal error.
Query Optimization and
Performance on
page 10-66
FLOATTYPE
Controls whether the
output of FLOAT data
types should be treated as
Tandem FLOAT or IEEE
FLOAT.
Data Types on
page 10-51
Attribute (page 2 of 9) Description Category