When subqueries are not flattened or materialized, a subquery cache is created to store results of earlier executions of the subquery. This reduces the number of expensive executions of the subquery.
