Subquery Unnesting
Subqueries are nested when they appear in the WHERE clause of the parent statement. When Oracle Database evaluates a statement with a nested subquery, it must evaluate the subquery portion multiple times and may overlook some efficient access paths or joins.Subqueries are nested when they
阅读背景：
Query Transformations : Subquery unnesting(原创)
来源：互联网
分享到：
