Warning:
As of May 16, 2023, CockroachDB v21.2 is no longer supported. For more details, refer to the Release Support Policy.
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.
Was this helpful?
