SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—544517-008
10-33
Default Attributes
Default Attributes
Default attributes control these activities:
Constraint Droppable Options
Data Types
Function Control
Histograms
Isolation Level
Locking
Local Autonomy
Module Management
National Character Set
Nonaudited Tables
Object Naming
Partition Management
Query Optimization and Performance
Query Plan Caching
Referential Action
Row Maintenance
Scratch Disk Management
Sequence Functions
Statement Atomicity
Statement Recompilation
Stored Procedures in Java
Stream Access
Table Management
Trigger Management
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-57
ATTEMPT_ASYNCHRONOUS_
ACCESS
Controls no-wait access
for partitions.
Query Optimization and
Performance on
page 10-57
ATTEMPT_ESP_PARALLELISM
Controls whether the
optimizer generates and
costs plans that use ESP
parallelism.
Query Optimization and
Performance on
page 10-57
AUTOMATIC_ RECOMPILATION
Determines whether a
statement is recompiled if
its access plan is no
longer valid at run time.
Statement
Recompilation on
page 10-69