Building a Query Optimizer from Scratch Part 1

Ever wondered how databases execute your queries efficiently? In this session, we'll build a query optimizer from the ground up in just 2 hours. You'll learn the core concepts behind query optimization, from parsing SQL and building execution plans to applying cost-based transformations by implementing them ourselves. We'll start with a simple SQL query, walk through plan generation, and progressively add optimization techniques. By the end, you'll understand the fundamental principles that powers real database optimizers.

Provide a detailed insights, how query optimizers works internally by building a simple one from scratch