SQL/MX 2.x Reference Manual (H06.04+)

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