Skip to main content

What is cost based optimization?

In this video, Andy Woods, a senior product manager at Cockroach labs, explains what cost based optimization is and how it works. He explains cost based optimization within the context of an actual SQL query being written by a developer and addresses common cost based optimization questions like the ones below: 0:29 What is cost based optimization? 1:11 What does a cost based optimizer do? 1:24 How does a cost based optimizer pick query plans? 1:40 What is Cardinality? Relevant Cost Based Optimization links: How We Built a Cost-Based SQL Optimizer https://www.cockroachlabs.com/blog/building-cost-based-sql-optimizer/ Query Plan Caching in CockroachDB: https://www.cockroachlabs.com/blog/query-plan-caching-in-cockroachdb/ What’s New in CockroachDB’s Cost-Based Query Optimizer https://www.cockroachlabs.com/blog/cost-based-optimizer-20-1/ ---------- Careers: https://www.cockroachlabs.com/careers CockroachCloud: https://www.cockroachlabs.com/product/cockroachcloud/ Blog: https://www.cockroachlabs.com/blog/ Docs: https://www.cockroachlabs.com/docs/stable/ Community Slack: https://cockroa.ch/Welcome-to-Slack Twitter: https://twitter.com/CockroachDB