SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

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