Does CockroachDB support JOINs?

We recently added support for JOINs. It’s not 100% optimized (so it can be slow on large datasets), but is pretty legit because it supports ORMs on day 1.

We’ve got more info in a blog post here:

If you have more questions or anything, would love to get feedback to the devs.

How much longer will it take to optimize joins?

@aman, we’ve been working on ways to distribute SQL processing across multiple nodes and move computation closer to the data, which will certainly optimize JOIN performance. Initial improvements should be rolled out sometime this quarter.

For more details about our distributed SQL work, you can read through the original RFC.