Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
correlated subqueries, optimizers perform equivalence conversion on the Correlatedjoin operator in the initial phase. The transformed logic tree computes the correlated subquery results by using common operators such as join and aggregation. This process is called decorrelation or unnesting. The