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

Metadata Tables
HP NonStop SQL/MX Reference Manual—544517-008
10-36
Default Attributes
HIST_NO_STATS_ROWCOUNT Estimated row count when
histogram statistics do not
exist.
Histograms on
page 10-43
HIST_NO_STATS_UEC
Estimated unique entry
count (UEC) when
histogram statistics do not
exist.
Histograms on
page 10-43
HIST_PREFETCH
Determines if histograms
are prefetched for
caching.
Histograms on
page 10-43
HIST_ROWCOUNT_
REQUIRING_STATS
Minimum row count that
determines when
warnings are issued to
update statistics.
Histograms on
page 10-43
HIST_SAME_TABLE_PRED_
REDUCTION
Controls overlap amount
in predicate selectivity
when multicolumn
predicates are used.
Histograms on
page 10-43
HIST_SCRATCH_VOL
Sets the physical volume
for UPDATE STATISTICS
temporary tables.
Histograms on
page 10-43
HIST_SECURITY_WARNINGS
Controls whether
warnings on histogram
tables are displayed.
Histograms on
page 10-43
INDEX_ELIMINATION_LEVEL
Indicates the degree of
heuristic elimination of
indexes consideration by
the optimizer.
Query Optimization and
Performance on
page 10-57
INFER_CHARSET Enable character set
inference for ODBC 2.X.
Query Optimization and
Performance on
page 10-57
INSERT_VSBB
Controls method of
inserting rows into a table.
Row Maintenance on
page 10-66
INTERACTIVE_ACCESS
Determines whether the
compiler selects index-
based access plans.
Statement
Recompilation on
page 10-69
ISOLATION_LEVEL
Default transaction
isolation level.
Isolation Level on
page 10-47
IUD_NONAUDITED_
INDEX_MAINT
Controls whether NonStop
SQL/MX allows insert/
update/delete operations
on nonaudited tables that
require index
maintenance.
Nonaudited Tables on
page 10-50
Attribute (page 4 of 9) Description Category