Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
about in many articles. This article describes the defects of such rewriting. If the private key does not indicate that the agg function is sensitive to duplicates, the window operator will block the filter-join pushdown. This interrupts joingraph, thus increasing the intermediate result of join.