The Oracle optimizer often changes the query to get better performance. In this article, Jonathan Lewis explains two more optimizations involving subqueries.
The post Oracle optimizer removing or coalescing subqueries appeared first on SQLServerCentral.
