SQL Parser & Query Optimizer
Learn SQL Parser & Query Optimizer (MySQL Architecture, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.
Introduction The parser turns SQL text into a parse tree and checks syntax; the optimizer rewrites it and chooses a cost-based execution plan (index choice, join order, join algorithm).