SQL$HELP72.HLB  —  SET_OPTIMIZATION_LEVEL, Arguments  optimization-level
    Specifies the optimizer strategy to be used to reset session
    defaults. The passed string or parameter value must be a
    formatted list of keyword values. Select from the following
    options:

    o  AGGRESSIVE SELECTIVITY option if you expect a small number of
       rows to be selected.

    o  DEFAULT option to accept the Oracle Rdb defaults: FAST FIRST
       and DEFAULT SELECTIVITY.

    o  FAST FIRST option if you want your program to return data to
       the user as quickly as possible, even at the expense of total
       throughput.

    o  SAMPLED SELECTIVITY option to use literals in the query to
       perform preliminary estimation on indexes.

    o  TOTAL TIME option if you want your program to run at the
       fastest possible rate, returning all the data as quickly as
       possible. If your application runs in batch, accesses all the
       records in a query, and performs updates or writes reports,
       you should specify TOTAL TIME.

    Only one of the TOTAL TIME or FAST FIRST options can be selected.
    Only one of the AGGRESSIVE SELECTIVITY or SAMPLED SELECTIVITY
    options can be selected. Use a comma to separate the keywords and
    enclose the list in parentheses. No other options may be included
    if DEFAULT is selected.
Close Help