SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—640322-001
10-44
Default Attributes
SCRATCH_DISKS Restricts scratch disks for
sort operations to the
volumes specified.
Scratch Disk
Management on
page 10-72
SCRATCH_DISKS_ EXCLUDED
Excludes certain volumes
from being used as
scratch disks for sort
operations.
Scratch Disk
Management on
page 10-72
SCRATCH_DISKS_ PREFERRED
Volumes preferred as
scratch disks for sort
operations.
Scratch Disk
Management on
page 10-72
SCRATCH_FREESPACE_
THRESHOLD_PERCENT
Amount of scratch space
left on disks as a
threshold.
Scratch Disk
Management on
page 10-72
SIMILARITY_CHECK
Determines whether
similarity checks are
made to either keep or
recompile an access plan.
Statement
Recompilation on
page 10-74
SKIP_UNAVAILABLE_PARTITION
controls whether SQL
continues to process a
query when a partition
required by the access
plan of the query is
unavailable.
Local Autonomy on
page 10-55
SORT_MAX_HEAP_SIZE_MB
Allocates a default value
to the heap memory size
for operations involving
the sort operator.
Query Optimization and
Performance on
page 10-63
STREAM_TIMEOUT
Default time for a fetch
operation using stream
access to wait for more
rows before timing out.
Stream Access on
page 10-76
TABLELOCK
Default when table locks
are used.
Locking on page 10-54
TEMPORARY_TABLE_
HASH_PARTITIONS
Specifies partitioning for
trigger temporary tables.
Trigger Management on
page 10-79
TIMEOUT
Default time to wait for a
lock before NonStop
SQL/MX returns a timeout
error.
Locking on page 10-54
UNION_TRANSITIVE_PREDICATE
S
Controls the union
transitive predicates.
Query Optimization and
Performance on
page 10-63
Attribute (page 8 of 9) Description Category