SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—523725-004
10-32
Default Attributes
CATALOG Default ANSI catalog
name.
Object Naming on
page 10-47
CROSS_PRODUCT_CONTROL
Determines whether plans
are eliminated that contain
unnecessary
cross-products.
Query Optimization and
Performance on
page 10-53
DATA_FLOW_OPTIMIZATION
Controls whether query
plans are considered that
have high data flow rates.
Query Optimization and
Performance on
page 10-53
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-50
DEF_MAX_HISTORY_ ROWS
Default for number of
rows the SEQUENCE BY
operator keeps in its
history buffer.
Sequence Functions on
page 10-61
DP2_CACHE_4096_BLOCKS
Specifies blocks allocated
for disk cache.
Query Optimization and
Performance on
page 10-53
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-40
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-53
FLOATTYPE
Controls whether the
output of FLOAT data
types should be treated as
Tandem FLOAT or IEEE
FLOAT.
Data Types on
page 10-39
GENERATE_EXPLAIN
Controls whether
EXPLAIN output is
generated.
Query Optimization and
Performance on
page 10-53
GEN_EIDR_BUFFER_SIZE
Buffer size for partition
access.
Query Optimization and
Performance on
page 10-53
Attribute Description Category