OPTIMIZER_INDEX_CACHING
This lets you adjust the behavior of cost-based optimization to favor nested loops joins and IN-list iterators.
| Property | Description |
| Parameter type | Integer |
| Default value | 0 |
| Recommended Value | 90 |
| Range of values | 0 to 100 |
Oracle FLEXCUBE relevance
This lets you adjust the behavior of cost-based optimization to favor nested loops joins and IN-list iterators.
Parent topic: Database Initialization Parameters