Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
the logic plan after pushing down the correlated join and rewriting it as left join based on the conversion rules. The scalar subquery serves as a filter condition. As such, the subquery does not return null result and the corresponding external query will definitely be filtered out. So,