Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
following figure. Conversion Rule Three: Pushdown through Filter According to the paper, correlatedjoin* can be directly pushed down through the filter. However, if correlatedjoin is to be pushed down, the filter needs to be rewritten as a project with "case when". If the rows in the subquery do