Alibabacloud, Database, Query Optimization, Sql, Relational Databases.
traditional optimizers for join and agg are much better than for window and the optimization rules are much richer. To sum up, it is necessary to estimate the benefit and cost when using window to rewrite a correlated subquery. Correlated Join Pushdown in External Queries Before pushing down