2.13 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 Values | 50 |
| Range of values | 1 to 10000 |
Oracle Banking Trade Finance relevance
Oracle Banking Trade Finance 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