I published an article on the Cockroach Labs Blog:
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.
So what do you think? Did I miss something? Is any part unclear? Leave your comments below.