Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
because the external query includes all tables and conditions of the subquery. Additionally, the agg function min satisfies . If not, the rows need to be marked and the output needs to be rewritten by using case when statement. The number of tablescan operations after the rewriting is notably