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

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