Warning:Cockroach Labs will stop providing Assistance Support for v21.2 on May 16, 2023. Prior to that date, upgrade to a more recent version to continue receiving support. For more details, see 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.