Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
CorrelatedJoin eliminates the previous top-down execution mode of the logic tree. A common logic tree is executed from the leaf node to the root node. However, the row values in the left subtree of CorrelatedJoin will be brought to its right subtree and executed repeatedly. The correlatedjoin node