SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—523725-004
10-37
Default Attributes
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-58
QUERY_CACHE_STATEMENT_
PINNING
Controls the pinning and
unpinning of query cache
entries.
Query Plan Caching on
page 10-58
READONLY_CURSOR
Controls whether FOR
UPDATE is required for
cursor declarations for
columns to be updatable.
Row Maintenance on
page 10-59
RECOMPILATION_ WARNINGS
Determines whether a
warning is returned when
a statement is dynamically
recompiled.
Statement
Recompilation on
page 10-62
REF_CONSTRAINT_NO_
ACTION_LIKE_RESTRICT
Determines how NonStop
SQL/MX handles
referential action in
ALTER TABLE and
CREATE TABLE
statements.
Referential Action on
page 10-59
REMOTE_ESP_ALLOCATION
Identifies the scope the
optimizer considers when
determining the active
systems.
Query Optimization and
Performance on
page 10-53
SAVE_DROPPED_TABLE _DDL
Controls whether
definitions of dropped
tables or partitions are
saved, to enable them to
be recovered.
Table Management on
page 10-65
SCHEMA
Default ANSI schema
name.
Object Naming on
page 10-47
SCRATCH_DISKS
Restricts scratch disks for
sort operations to the
volumes specified.
Scratch Disk
Management on
page 10-60
SCRATCH_DISKS_ EXCLUDED
Excludes certain volumes
from being used as
scratch disks for sort
operations.
Scratch Disk
Management on
page 10-60
SCRATCH_DISKS_ PREFERRED
Volumes preferred as
scratch disks for sort
operations.
Scratch Disk
Management on
page 10-60
Attribute Description Category