This article aims to sort the usage and internal implementation of joins.
This article introduces how MySQL 8.0 optimizer turns a simple string into an execution sequence the database executor can return the data to the client.
This article introduces the complex transformation process of subqueries, partitioned tables, and JOIN operations.
This article describes the definition of materialized view for databases and ways to rewrite queries based on it.
This article explores several ways for implementing join on distributed databases, namely Lookup Join using PolarDB-X.