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.
Part 1 of this series introduces the theoretical basis and focuses on various high-end SQL operations.
Part 2 of this series focuses on various SQL syntaxes.
This article introduces the parser technology and its current situation in the industry, including problems, design and practice, and performance improvements.