All well-known open-source products (such as MySQL, Spark, and Presto) have optimizers. This article explains the principle of SQL optimizers with an easy-to-understand approach.
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 blog introduces the AnalyticDB for PostgreSQL Auto Analyze Feature and discusses how it helps users collect more accurate statistical information.