SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Metadata Tables
HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001
10-47
Default Attributes
SCRATCH_DISKS Restricts scratch disks for
sort operations to the
volumes specified.
Scratch Disk
Management on
page 10-75
SCRATCH_DISKS_ EXCLUDED
Excludes certain volumes
from being used as
scratch disks for sort
operations.
Scratch Disk
Management on
page 10-75
SCRATCH_DISKS_ PREFERRED
Volumes preferred as
scratch disks for sort
operations.
Scratch Disk
Management on
page 10-75
SCRATCH_FREESPACE_
THRESHOLD_PERCENT
Amount of scratch space
left on disks as a
threshold.
Scratch Disk
Management on
page 10-75
SIMILARITY_CHECK
Determines whether
similarity checks are
made to either keep or
recompile an access plan.
Statement
Recompilation on
page 10-77
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-58
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-66
STREAM_TIMEOUT
Default time for a fetch
operation using stream
access to wait for more
rows before timing out.
Stream Access on
page 10-79
TABLELOCK
Default when table locks
are used.
Locking on page 10-57
TEMPORARY_TABLE_
HASH_PARTITIONS
Specifies partitioning for
trigger temporary tables.
Trigger Management on
page 10-82
TIMEOUT
Default time to wait for a
lock before NonStop
SQL/MX returns a timeout
error.
Locking on page 10-57
UNION_TRANSITIVE_PREDICATE
S
Controls the union
transitive predicates.
Query Optimization and
Performance on
page 10-66
Attribute (page 8 of 9) Description Category