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

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-35
Default Attributes
HIST_ROWCOUNT_
REQUIRING_STATS
Minimum row count that
determines when
warnings are issued to
update statistics.
Histograms on
page 10-41
HIST_SAME_TABLE_PRED_
REDUCTION
Controls overlap amount
in predicate selectivity
when multicolumn
predicates are used.
Histograms on
page 10-41
HIST_SCRATCH_VOL
Sets the physical volume
for UPDATE STATISTICS
temporary tables.
Histograms on
page 10-41
HIST_SECURITY_WARNINGS
Controls whether
warnings on histogram
tables are displayed.
Histograms on
page 10-41
INDEX_ELIMINATION_LEVEL
Indicates the degree of
heuristic elimination of
indexes consideration by
the optimizer.
Query Optimization and
Performance on
page 10-54
INSERT_VSBB
Controls method of
inserting rows into a table.
Row Maintenance on
page 10-61
INTERACTIVE_ACCESS
Determines whether the
compiler selects index-
based access plans.
Statement
Recompilation on
page 10-64
ISOLATION_LEVEL
Default transaction
isolation level.
Isolation Level on
page 10-45
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-48
JOIN_ORDER_BY_USER
Enables or disables join
order you specify in the
FROM clause of a query.
Query Optimization and
Performance on
page 10-54
MATERIALIZE
Default for whether inner
tables of join operations
with streams are
materialized.
Stream Access on
page 10-66
MAX_ESPS_PER_CPU_PER_OP
Maximum number of
ESPs the optimizer
considers starting for each
CPU for a given operator.
Query Optimization and
Performance on
page 10-54
Attribute Description Category