Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
following section mainly describes common decorrelation methods. Common Decorrelation Methods For convenience, this section will only discuss scalar correlated subqueries, which output a column of values. Before discussing about decorrelation, the characteristics of correlation subquery output are