Place
Noplace
Sorts records by target page number before they are stored.
The Place qualifier automatically builds an ordered set of
database keys (dbkeys) when loading data and automatically stores
the records in dbkey order, sequentially, page by page. During
a parallel load operation, each worker executor builds its own
ordered set of dbkeys.
The number of work files used by the RMU Load command is
controlled by the RDMS$BIND_SORT_WORKFILES logical name. The
allowable values are 1 through 10 inclusive, with a default value
of 2. The location of these work files can be specified with
device specifications, using the SORTWORKn logical name (where n
is a number from 0 to 9). See the OpenVMS documentation set for
more information on using SORT/MERGE. See the Oracle Rdb7 Guide
to Database Performance and Tuning for more information on using
these Oracle Rdb logical names.
A significant performance improvement occurs when the records
are stored by means of a hashed index. By using the Commit_
Every qualifier with the Place qualifier, you can specify how
many records to load between COMMIT statements. Performance may
actually decrease when records are stored by means of a sorted
index.
The default is the Noplace qualifier.