SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—640322-001
10-37
Default Attributes
This table provides a quick reference to the attributes you can set or override with the
SYSTEM_DEFAULTS table:
Attribute (page 1 of 9) Description Category
ALLOW_DP2_ROW_SAMPLING
Determines whether the
sampling is done by the
DP2 or the SQL/MX
Executor.
Query Optimization and
Performance on
page 10-63
ANSI_STRING_FUNCTIONALITY
Determines the behavior
of the LPAD and RPAD
functions. A value set to
ON will pad the string with
the specified characters.
A value set to OFF will
replace the string with the
specified characters. For
more information, see
Examples of LPAD
and
Examples of RPAD
.
Function Control
on
page 10-49
ATTEMPT_ASYNCHRONOUS_
ACCESS
Controls no-wait access
for partitions.
Query Optimization and
Performance on
page 10-63
ATTEMPT_ESP_PARALLELISM
Controls whether the
optimizer generates and
costs plans that use ESP
parallelism.
Query Optimization and
Performance on
page 10-63
AUTOMATIC_ RECOMPILATION
Determines whether a
statement is recompiled if
its access plan is no
longer valid at run time.
Statement
Recompilation on
page 10-74
CACHE_HISTOGRAMS
Controls whether the
optimizer caches
histograms.
Histograms on
page 10-49
CACHE_HISTOGRAMS_
REFRESH_INTERVAL
Controls interval at which
histograms are refreshed.
Histograms on
page 10-49
CATALOG
Default ANSI catalog
name.
Object Naming on
page 10-57
CHECK_CONSTRAINT_PRUNING
Controls the check
constraints pruning
optimization.
Query Optimization and
Performance on
page 10-63
CREATE_DEFINITION_SCHEMA_V
ERSION
Assigns schema version
to new schemas.
Metadata Management
on page 10-56
CROSS_PRODUCT_CONTROL
Determines whether plans
are eliminated that contain
unnecessary
cross-products.
Query Optimization and
Performance on
page 10-63