Query Optimization

PostgreSQL Sorting Deduplication and Limit Query Optimization – Recursion vs. Group

This short article explains how PostgreSQL works with deduplication and limit query optimization.

Query Optimization Technology for Correlated Subqueries

This article describes what correlated subqueries are and how to rewrite correlated subqueries as SQL queries in common semantics.

MaxCompute Query Optimization with Calcite

In this article, Senior Development Engineer Lei Chunwei introduces the concept of query optimization and its implementation on MaxCompute with Calcite.