Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
Details are not provided here. The paper Orthogonal Optimization of Subqueries and Aggregation[1] repeatedly pushes correlated join down based on these rules until it is converted into common join. Take the previous tpch q17 as the example again. Push correlated join down to project in the subquery