Set the SUBQUERY_CACHING_PREFERENCE option to choose caching methods for a correlated subquery.
A correlated subquery contains references to one or more tables outside of the subquery and is re-executed each time the value in the referenced column changes. Use the SUBQUERY_CACHING_PREFERENCE option to choose caching methods for executing the correlated subquery.