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

Metadata Tables
HP NonStop SQL/MX Reference Manual—523725-004
10-34
Default Attributes
HIST_SAME_TABLE_PRED_
REDUCTION
Controls overlap amount
in predicate selectivity
when multicolumn
predicates are used.
Histograms on
page 10-40
HIST_SCRATCH_VOL
Sets the physical volume
for UPDATE STATISTICS
temporary tables.
Histograms on
page 10-40
HIST_SECURITY_WARNINGS
Controls whether
warnings on histogram
tables are displayed.
Histograms on
page 10-40
INDEX_ELIMINATION_LEVEL
Indicates the degree of
heuristic elimination of
indexes consideration by
the optimizer.
Query Optimization and
Performance on
page 10-53
INSERT_VSBB
Controls method of
inserting rows into a table.
Row Maintenance on
page 10-59
INTERACTIVE_ACCESS
Determines whether the
compiler selects index-
based access plans.
Statement
Recompilation on
page 10-62
ISOLATION_LEVEL
Default transaction
isolation level.
Isolation Level on
page 10-44
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-47
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-53
MATERIALIZE
Default for whether inner
tables of join operations
with streams are
materialized.
Stream Access on
page 10-64
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-53
MAX_ROWS_LOCKED_
FOR_STABLE_ACCESS
Maximum number of rows
that are locked in STABLE
ACCESS mode.
Locking on page 10-45
Attribute Description Category