Anatomy Of A SQL Engine
May marks five years since Dolt adopted go-mysql-server. Today we summarize the current state of GMS by walking through a query's journey from parsing to result spooling.
Overview
SQL engines are the logical layer of a database that sit between client
and storage. To mutate the database state on behalf of a client, a SQL
engine performs the following steps:
Parsing
Binding
Plan Simplification
Join Exploration
Plan Costing
Execution
Spooling Results
Most systems also have a variety of execution
s...
Read more at dolthub.com