SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Metadata Tables
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
10-42
Default Attributes
GENERATE_EXPLAIN Controls whether
EXPLAIN output is
generated.
Query Optimization and
Performance on
page 10-68
GEN_EIDR_BUFFER_SIZE
Buffer size for partition
access.
Query Optimization and
Performance on
page 10-68
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-64
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-64
GEN_PA_BUFFER_SIZE
Buffer size for partition
access.
Query Optimization and
Performance on
page 10-68
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-53
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-53
HIST_JOIN_CARD_ LOWBOUND
Controls join cardinality. Histograms on
page 10-53
HIST_NO_STATS_REFRESH_
INTERVAL
Controls the interval at
which default statistics are
refreshed.
Histograms on
page 10-53
HIST_NO_STATS_ROWCOUNT
Estimated row count when
histogram statistics do not
exist.
Histograms on
page 10-53
HIST_NO_STATS_UEC
Estimated unique entry
count (UEC) when
histogram statistics do not
exist.
Histograms on
page 10-53
HIST_PREFETCH
Determines if histograms
are prefetched for
caching.
Histograms on
page 10-53
Attribute (page 3 of 9) Description Category