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

Metadata Tables
HP NonStop SQL/MX Reference Manual—544517-008
10-35
Default Attributes
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-57
FLOATTYPE
Controls whether the
output of FLOAT data
types should be treated as
Tandem FLOAT or IEEE
FLOAT.
Data Types on
page 10-42
GENERATE_EXPLAIN
Controls whether
EXPLAIN output is
generated.
Query Optimization and
Performance on
page 10-57
GEN_EIDR_BUFFER_SIZE
Buffer size for partition
access.
Query Optimization and
Performance on
page 10-57
GEN_MAX_NUM_PART_
DISK_ENTRIES
Controls the size of a
partition list prepared by
the compiler and used by
the executor.
Partition Management
on page 10-54
GEN_MAX_NUM_PART_
NODE_ENTRIES
Controls the size of a
partition list prepared by
the compiler and used by
the executor.
Partition Management
on page 10-54
GEN_PA_BUFFER_SIZE
Buffer size for partition
access.
Query Optimization and
Performance on
page 10-57
HIST_DEFAULT_SEL_FOR_
LIKE_WILDCARD
Specifies the selectivity
factor used by the
optimizer for LIKE
predicates where the
matched pattern starts
with a wildcard.
Histograms on
page 10-43
HIST_DEFAULT_SEL_FOR_
PRED_RANGE
Specifies the selectivity
factor used by the
optimizer for range
predicates when current
histogram statistics do not
exist.
Histograms on
page 10-43
HIST_JOIN_CARD_ LOWBOUND
Controls join cardinality. Histograms on
page 10-43
HIST_NO_STATS_REFRESH_
INTERVAL
Controls the interval at
which default statistics are
refreshed.
Histograms on
page 10-43
Attribute (page 3 of 9) Description Category