2.12 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 Values | 90 |
| Range of values | 0 to 100 |
Oracle Banking Trade Finance relevance
The cost of executing an index using IN-list iterators or of executing nested loops join when an index is used to access the inner table depends on the caching of that index in the buffer cache. Oracle Banking Trade Finance favors nested loop joins by setting optimizer_index_caching to 90.
Parent topic: Database Initialization Parameters