Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
example above, the subquery output of correlatedjoin for the same p.partkey values is the same. As shown in the following figure, if the value of the external query partkey is 25, the generated correlated subqueries are the same and so are the results. Newmann’s paper Unnesting Arbitrary Queries