SQL/MX 2.x Reference Manual (H06.04+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-32
Default Attributes
Default Attributes
Default attributes control these activities:
Constraint Droppable Options
Data Types
Function Control
Histograms
Isolation Level
Locking
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 Description Category
ATTEMPT_ASYNCHRONOUS_
ACCESS
Controls no-wait access
for partitions.
Query Optimization and
Performance on
page 10-54
ATTEMPT_ESP_PARALLELISM
Controls whether the
optimizer generates and
costs plans that use ESP
parallelism.
Query Optimization and
Performance on
page 10-54
AUTOMATIC_ RECOMPILATION
Determines whether a
statement is recompiled if
its access plan is no
longer valid at run time.
Statement
Recompilation on
page 10-64
CACHE_HISTOGRAMS
Controls whether the
optimizer caches
histograms.
Histograms on
page 10-41
CACHE_HISTOGRAMS_
REFRESH_INTERVAL
Controls interval at which
histograms are refreshed.
Histograms on
page 10-41