Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
scalar subqueries. For example, exists subqueries can be rewritten as count(*) > 0. However, if the results returned by the subquery are used to filter rows of the external query, the entire decorrelation process will actually be simplified. Therefore, subqueries such as exists and in are specially