Skip to main content

How to add secondary indexes

In this Cockroach University lesson titled “How to add secondary indexes”, you will learn a common cause of database performance problems, how indexes make filtering options more efficient, and why developers should care about using performant data structures. In this lesson, you will learn: •00:00 Why databases use indexes •0:32 Common database performance problems •1:51 How to add a secondary index to your app •2:23 The benefits of using a secondary index as your app scales * This video is an expert from our course, "CockroachDB for Python Developers". Learn more about CockroachDB by signing up for free training at Cockroach University: https://university.cockroachlabs.com/ ---------- Reference Links •SQL Performance Best Practices: https://www.cockroachlabs.com/docs/v19.2/performance-best-practices-overview.html (CockroachDB Docs) •Indexes: https://www.cockroachlabs.com/docs/v19.2/indexes.html (CockroachDB Docs) ---------- Careers: https://www.cockroachlabs.com/careers CockroachCloud: https://www.cockroachlabs.com/product/cockroachcloud/ Blog: https://www.cockroachlabs.com/blog/ Docs: https://www.cockroachlabs.com/docs/stable/ Community Slack: https://cockroa.ch/Welcome-to-Slack Twitter: https://twitter.com/CockroachDB