Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
correlated join operator can be converted into common left join operator without join criteria. Note: enforcesinglerow must be added to the subquery to ensure that the semantics of the join operator are the same as that of correlated join. That is, the input will not inflate. Conversion Rule Two: