SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

Metadata Tables
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
10-40
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-66
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-52
ATTEMPT_ASYNCHRONOUS_
ACCESS
Controls no-wait access
for partitions.
Query Optimization and
Performance on
page 10-66
ATTEMPT_ESP_PARALLELISM
Controls whether the
optimizer generates and
costs plans that use ESP
parallelism.
Query Optimization and
Performance on
page 10-66
AUTOMATIC_ RECOMPILATION
Determines whether a
statement is recompiled if
its access plan is no
longer valid at run time.
Statement
Recompilation on
page 10-78
CACHE_HISTOGRAMS
Controls whether the
optimizer caches
histograms.
Histograms on
page 10-52
CACHE_HISTOGRAMS_
REFRESH_INTERVAL
Controls interval at which
histograms are refreshed.
Histograms on
page 10-52
CATALOG
Default ANSI catalog
name.
Object Naming on
page 10-60
CHECK_CONSTRAINT_PRUNING
Controls the check
constraints pruning
optimization.
Query Optimization and
Performance on
page 10-66
CREATE_DEFINITION_SCHEMA_V
ERSION
Assigns schema version
to new schemas.
Metadata Management
on page 10-59
CROSS_PRODUCT_CONTROL
Determines whether plans
are eliminated that contain
unnecessary
cross-products.
Query Optimization and
Performance on
page 10-66