Cost-Based Optimizer

Analysis of MySQL Cost Estimator

This article introduces the principle of cost estimation and the implementation details of MySQL.

The Principle of SQL Optimizer

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.

Making SQL Optimizer More Accurate: AnalyticDB for PostgreSQL Auto Analyze Feature

This blog introduces the AnalyticDB for PostgreSQL Auto Analyze Feature and discusses how it helps users collect more accurate statistical information.

Optimizations with Full-Text Search in PostgreSQL

This article shows how PostgreSQL, equipped with both GIN indexes and the cost-based optimizer (CBO), can automatically choose the most optimal query method.