Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
equivalence conversion rules of pushing the correlatedjoin* operator down to other operators (such as filter, project, aggregation, and union) are given in the paper Orthogonal Optimization of Subqueries and Aggregation5. However, the correlatedjoin* operator filters the number of rows of the