Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
the external query need to be assigned to the subquery and then scanned with each row of the subquery. By doing so, the output can be determined when the subquery satisfies t2.c1 > t1.c1. The cost of computing cannot be reduced through optimization. Fortunately, the output is always the same for