I published an article on the Cockroach Labs Blog:
On the Way to Better SQL Joins in CockroachDB.
In this article, I explain how I improved the first design of SQL joins in CockroachDB to support basic forms of optimizations in CockroachDB v1.0.
Also available via the Wayback Machine.