Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
correlatedJoin towards the subquery, correlatedjoin is pushed down first in the external query. For example, it is pushed down through cross join etc. The correlatedJoin operator will never cause data expansion, so, theoretically, the pushdown should be done earlier. In fact, correlatejoin pushdown