Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
Conversion to Join with Simple Correlation Conditions When the top node in the right subtree of the correlated join is a correlated filter without correlation beneath, the filter can directly serve as a criteria of the left join. It can also be understood as filter lifting, as shown in the