This article introduces SLS Materialized Views, which speed up log queries by 100x and cut resource use by 90% via pre-computation and auto query rewriting.
This article offers basic knowledge about the filter condition pushdown principle and its advantages and disadvantages.
This short article explains how PostgreSQL works with deduplication and limit query optimization.
This article describes what correlated subqueries are and how to rewrite correlated subqueries as SQL queries in common semantics.
In this article, Senior Development Engineer Lei Chunwei introduces the concept of query optimization and its implementation on MaxCompute with Calcite.
