I have view emp (jdbc) and view ad (LDAP). AD is a partially cached view. We join emp.id to ad.id and it works great.
Now I need to also join emp.supervisor_id to ad.id to get the supervisor information. When I look at the execution trace, it appears to do 2 different fetches from the cache.
Is there a way to have it fetch from the cache only once, and re-use those results for the second join? I'm just joining them in the GUI and am taking the default execution plan.