Dear all,
what are the restrictions for using result cache hint on queries? Like using it on union or join or subqueries? Which doc should I read regarding to it?
Also I run the following queries on HR sample schema:
select first_name,(select /*+ RESULT_CACHE */ last_name from employees where employee_id=100) from employees;
select first_name from (select /*+ RESULT_CACHE */ first_name from employees);
Using
select name, value from v$result_cache_statistics where id=7;
I can verify if the first subquery, where it's evaluated in each row, doesn't use result cache hint whereas the second on uses on. How so?
Best regards,
Val