In this article, Jonathan Lewis discusses why you might want to stop the optimizer from unnesting some subqueries and how to control where the optimizer positions each subquery.
The post Oracle subquery caching and subquery pushing appeared first on SQLServerCentral.
