SQL$HELP72.HLB  —  CREATE  OUTLINE  Arguments  MODE mode
    Mode is a value assigned to an outline when it is generated by
    the optimizer. The default mode is 0. Specify a signed integer.

    If you create multiple outlines for a single query, the outlines
    cannot have the same outline mode. When more than one outline
    exists for a query, you can set the RDMS$BIND_OUTLINE_MODE
    logical name to the value of the outline mode for the outline you
    want the optimizer to use. For example, if you have a query that
    runs during the day and at night and you created two outlines for
    the query, you could keep the default outline mode of 0 for the
    outline to be used during the day, and assign an outline mode of
    -1 for the outline to be used at night. By setting the RDMS$BIND_
    OUTLINE_MODE logical name to -1 at night, the appropriate outline
    is run at the appropriate time.

    Valid values for modes are -2,147,483,648 to 2,147,483,647.
    Positive mode values are reserved for future use, so it is
    recommended that you specify a value between 0 and -2,147,483,648
    for the mode value.
Close Help