Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
above example, if the external query has a row of p.partkey whose value is 25, the corresponding output of the correlated join operation for this row is as follows. -- When p.partkey = 25, the corresponding subquery is SELECT 0.2 * Avg(l2.quantity) FROM lineitem l2 WHERE l2.partkey = 25 Note that