Databases Reference
In-Depth Information
We can see in the next screenshot, the change in the execution plan for the same query
mentioned above. However, to enable this behavior we have defined a size (greater than zero)
for the
CLIENT_RESULT_CACHE_SIZE
parameter. In the next section we will see how to obtain
the same behavior in a different way than just using hints in our queries.
There's more...
We can enable client-side result cache in three different ways:
1.
Using hints as in step 3 of our recipe.
2.
Enabling the result cache at a session (or system) level:
ALTER SESSION SET RESULT_CACHE_MODE = FORCE;
3.
With table annotation, we can instruct the database to use the result cache for
the queries against specific tables, using the following statement:
ALTER TABLE CUSTOMERS RESULT_CACHE (MODE FORCE);
