Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
subqueries. It is manifested in the plan to push the correlated join operator down below the correlation part on the right. When the left and right subtrees of a correlated join operator do not have correlated columns, the correlated join operator can be converted into a join operator. In this way,