Part 3 of this Series introduces aggregation subquery promotion, a rewrite strategy for aggregation-related subqueries, and the pitfalls of this rewrite strategy.
Part 2 of the OceanBase Rewriting Series focuses on the strategy of rewriting subqueries in existential determination predicates into SEMI/ANTI JOIN.
Part 1 of the OceanBase Rewriting Series focuses on OceanBase query rewriting practices.
This article describes the definition of materialized view for databases and ways to rewrite queries based on it.
