SQL$HELP72.HLB  —  CREATE  OUTLINE  Arguments  ACCESS_PATH
    Syntax options:

       ACCESS PATH ANY
       ACCESS PATH SEQUENTIAL
       ACCESS PATH DBKEY
       ACCESS PATH ROWID
       ACCESS PATH NO INDEX

    See also ACCESS_PATH_INDEX. Specifies the access path to use to
    retrieve data from the underlying database table. The following
    table lists the valid access paths.

    Path           Meaning

    ANY            Indicates that the optimizer may choose the most
                   appropriate method.
    SEQUENTIAL     Indicates that sequential access should be used.
    DBKEY          Indicates the access by database key should be
                   used.
    ROWID          Indicates the access by database key should be
                   used.
    NO INDEX       Indicates that any access path not requiring
                   an index can be used. NOINDEX is accepted as a
                   synonym for NO INDEX.

    There is no default access path. An access path must be specified
    for each database table specified within a query outline
    definition.
Close Help