Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
reduced. Moreover, the subsequent optimization rules exchanges the order of join and window according to the information of primary key and the characteristics of agg function. This further reduces the amount of data (filter-join pushdown) input by window operators. The benefits have been discussed