Skip to main content

How to use composite indexes

In this Cockroach University lesson titled “How to use composite indexes”, you will learn how to create a composite index, how queries use composite indexes to find results, and some limitations of composite indexes. In this lesson, you will learn: • 00:00 What are composite indexes? • 0:26 How to Build a Composite Index • 1:02 How Index Prefixes Work • 2:38 The Limitations of Index Prefixes Learn more about CockroachDB by signing up for free training at Cockroach University: https://university.cockroachlabs.com/ * A preview from our course, "Composite Indexes and Index Prefixes". ---------- Reference Links •Indexes: https://www.cockroachlabs.com/docs/v20.1/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