Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
aggregation and group by. The meaningless sort operations in the subquery can be filtered. On the other hand, during subquery rewriting, subqueries can be simplified through attribute deduction. For example: There is no need to add the uniqueid column to the originally unique external query.