OPTIMIZER_INDEX_COST_ADJ

OPTIMIZER_INDEX_COST_ADJ allows you to tune optimizer behavior for access path selection to be more or less index friendly; that is, to make the optimizer more or less prone to selecting an index access path over a full table scan. The default for this parameter is 100 percent, at which the optimizer evaluates index access paths at the regular cost. But Oracle Hyperion Financial Management transactions generally favor index access paths more than full table scan paths, so Oracle recommends a lower value for this parameter.

Suggested setting: 50