Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
to be executed twice, as shown in the following figure. In this case, the results of the input subtree need to be deterministic. Otherwise, this method cannot be used for decorrelation. Optimization of Correlated Subqueries The optimizer of ADB matches and converts the logic plan based on each