SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Metadata Tables
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
10-42
Default Attributes
GEN_EIDR_BUFFER_SIZE Buffer size for partition
access.
Query Optimization and
Performance on
page 10-66
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-63
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-63
GEN_PA_BUFFER_SIZE
Buffer size for partition
access.
Query Optimization and
Performance on
page 10-66
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-52
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-52
HIST_JOIN_CARD_ LOWBOUND
Controls join cardinality. Histograms on
page 10-52
HIST_NO_STATS_REFRESH_
INTERVAL
Controls the interval at
which default statistics are
refreshed.
Histograms on
page 10-52
HIST_NO_STATS_ROWCOUNT
Estimated row count when
histogram statistics do not
exist.
Histograms on
page 10-52
HIST_NO_STATS_UEC
Estimated unique entry
count (UEC) when
histogram statistics do not
exist.
Histograms on
page 10-52
HIST_PREFETCH
Determines if histograms
are prefetched for
caching.
Histograms on
page 10-52
HIST_ROWCOUNT_
REQUIRING_STATS
Minimum row count that
determines when
warnings are issued to
update statistics.
Histograms on
page 10-52
Attribute (page 3 of 9) Description Category