| Property | Description |
|---|---|
| Parameter type | String |
| Syntax | RESULT_CACHE_MODE = { MANUAL | FORCE } |
| Default value | MANUAL |
| Modifiable | ALTER SESSION, ALTER SYSTEM |
| Basic | No |
RESULT_CACHE_MODE specifies when a ResultCache operator is spliced into a query's execution plan.
Values:
MANUAL
The ResultCache operator is added only when the query is annotated (that is, hints).
FORCE
The ResultCache operator is added to the root of all SELECT statements (provided that it is valid to do so).
For the FORCE setting, if the statement contains a NO_RESULT_CACHE hint, then the hint takes precedence over the parameter setting.