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.