CockroachDB provides many features to improve query performance.
Indexes improve query performance by helping CockroachDB locate data without having to look through every row of a table. You typically add and tune indexes when designing your database schema.
The following features are automatically configured by CockroachDB and employed during query planning and execution:
- The cost-based optimizer seeks the lowest cost for a query, usually related to time.
- The vectorized execution engine supports column-oriented ("vectorized") query execution on all CockroachDB data types.
- Load-based splitting distributes load evenly across your cluster.