VMS Help  —  RMU72  Load  Database  Command Qualifiers, Place
    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.
Close Help