Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
down to the correlation part, it can be converted into a common join operator. After the correlated join operator is pushed down, the operators above the correlation join need to be rewritten to maintain equivalence. As shown in the figure above, subquery is changed to subquery’. Pushdown Rules The