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.
