Cockroach Labs Blog company blog

How We Built a Cost-Based SQL Optimizer

by Andy Kimball cockroachlabs.com published 2018-11-08

CockroachDB 2.1 includes a brand-new, built-from-scratch, cost-based SQL optimizer. This post explains what a cost-based SQL optimizer is, and tells the story of how we decided we really, really needed one.

Points

198

HN comments

52

Submissions

1

Cited by

0 commenters

Databases & DataSoftware Engineering2018

Related posts from the same era

Apple open-sources FoundationDB

FFoundationDB Blog20182,136 points441 comments details

Personal and social information of 1.2B people discovered in data leak

Data Viper Blog20191,439 points419 comments details

Congress votes to make open government data the default in the United States

E Pluribus Unum20181,130 points154 comments details

Introducing Cloud Spanner, a Global Database Service

Google Cloud Blog20171,068 points434 comments details

PostgreSQL 10 Released

PostgreSQL20171,024 points296 comments details

JupyterLab is ready for users

Jupyter Blog2018958 points248 comments details