Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
t1.c1 FROM t1 WHERE t1.c2 > ( SELECT min(t2.c2) FROM t2 WHERE t2.c1 > t1.c1 ); The following figure shows the plan after SQL1 is decorrelated. The following figure shows the plan after SQL2 is decorrelated. For SQL1, semantically, the cost is the same as that of inner join on equivalent condition,