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

Видео What is cost based optimization? канала CockroachDB