OPTIMIZER_INDEX_COST_ADJ
This lets you 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.
| Property | Description |
| Parameter type | Integer |
| Default value | 100 |
| Recommended Value | 50 |
| Range of values | 0 to 10000 |
Oracle FLEXCUBE relevance
FLEXCUBE favors index read over full table scan as it is very useful when optimizer favors to give a lower cost to index scans over full-table scans.
Parent topic: Database Initialization Parameters