Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
correlatedjoin can be directly converted into correlatedjoin*. Along with the filter lifting, the following plan can be obtained. The advantage is that aggregation (early agg) can be performed before join. As to the disadvantage, semantic inequivalence and count bug are easily to occur.