Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
broken after the decorrelation. It is hoped that the plan is optimized as much as possible during decorrelation. Correlated Subqueries of exists/in/filter For simplicity, only the scalar subqueries are discussed about in the previous section. The exists and in subqueries can also be rewritten as