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

Metadata Tables
HP NonStop SQL/MX Reference Manual—544517-008
10-39
Default Attributes
PRESERVE_MIN_SCALE Allows you to preserve
minimum scale in a result
when the precision
exceeds 18.
Function Control on
page 10-43
PRIMARY_KEY_CONSTRAINT_
DROPPABLE_OPTION
Default for DROPPABLE
(ON) or NOT
DROPPABLE for
PRIMARY KEY constraint.
Constraint Droppable
Options on page 10-42
QUERY_CACHE
Controls the maximum
amount of memory that
the SQL/MX compiler is
allowed to use for holding
the cached plans of
previously compiled
queries.
Query Plan Caching on
page 10-64
QUERY_CACHE_MAX_VICTIMS
Limits the number of
entries that an unusually
large query plan is
allowed to displace from
the cache.
Query Plan Caching on
page 10-64
QUERY_CACHE_REQUIRED_
PREFIX_KEYS
Determines how many
and which columns of a
composite primary or
partition key are required
for an equality key
predicate to be
considered cacheable.
Query Plan Caching on
page 10-64
QUERY_CACHE_STATEMENT_
PINNING
Controls the pinning and
unpinning of query cache
entries.
Query Plan Caching on
page 10-64
READONLY_CURSOR
Controls whether FOR
UPDATE is required for
cursor declarations for
columns to be updatable.
Row Maintenance on
page 10-66
RECOMPILE_ON_
PLANVERSION_ERROR
Determines whether a
statement is recompiled if
its access plan is no
longer valid at run time
due to versioning errors.
Statement
Recompilation on
page 10-69
RECOMPILATION_ WARNINGS
Determines whether a
warning is returned when
a statement is dynamically
recompiled.
Statement
Recompilation on
page 10-69
Attribute (page 7 of 9) Description Category