Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
mentioned at the beginning. Here are more explanations. Even if the correlation is decorrelated into operators such as join or agg, for some correlated subqueries, cross join is also required to compute the query results. There are two examples. The first one is a common correlated subquery which