Databases Reference
In-Depth Information
3.
Enable the use of the result cache using a hint and execute the same query
as in the previous step:
SELECT /*+ result_cache */
COUNTRY_NAME, CUST_LAST_NAME, COUNT(*)
FROM CUSTOMERS C, COUNTRIES CT
WHERE C.COUNTRY_ID = CT.COUNTRY_ID
GROUP BY COUNTRY_NAME, CUST_LAST_NAME;
SET AUTOT OFF
How it works...
In step 2 we have executed a simple join query. The execution plan is represented in the
following screenshot:
In step 3, we have used a specific hint
result_cache
to use the result cache (both client-side
and server-side).
