Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
first, and the query is as follows. Then, push correlation join through agg and rewrite agg, as shown in the following figure. Here, is ignored. Otherwise, all rows in the subquery need to be marked. The empty set is to be processed specially after the correlated join operation based on the