Chapter 6: How Indexes Work in CockroachDB
In Chapter 5, Fault Tolerance and Auto-Rebalancing, we learned about fault-tolerance and auto-recovery strategies in CockroachDB. In this chapter, we will learn everything about indexes, what they are, and how they improve query times.
Although indexes help improve the read performance, a wrong index can slow down the queries, including the writes, and take up more storage space. So, it is important to identify the query pattern and create appropriate indexes.
The following topics will be covered in this chapter:
- Introduction to indexes
- Different types of indexes
- Best practices while using indexes
Technical requirements
We will try creating various types of indexes in this chapter which would require ...
Get Getting Started with CockroachDB now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
